Overloaded functions only once in object browser

[Charles Wright]

We are evaluating PL/SQL Dev for general use in the organization, (I am trying to convince it is better than the very expensive SQL Nav 4.0).

SQL Nav shows all versions of a function, and the DBAs prefer being able to see the different signatures.

I saw an earlier post (Apr 2003) acknowledging this behaviour. Is a bug or a feature? Is it likely to change at any point?

Thanks,

Charlie.

 

[Marco Kalter]

It is a feature. Even though you don't see all overloaded versions of a program unit, you can select one as soon as you use it (Test, Describe, and so on). You are not the first to inquire about this though (especially when the overloaded versions include functions and procedures), so this will most likely change in the future.

 

[William Robertson]

I just came across this post when searching the board to see whether anyone had the same issue.

I can sort of see the logic of collapsing multiple overloadings, but it doesn't seem right to collapse a procedure and a function into one procedure, as it effectively hides the function.

 

[Marco Kalter]

This situation can indeed be confusing, and will be addressed in the next release.

 

[Ed Holloman]

Hi,

I'd just like to add my $0.02 to this feature request. I recently overloaded some packaged programs to avoid breaking existing functionality. Short of doing a describe, test script or opening the package, there was no quick way to indicate which ones were overloaded to quickly check parameters.

Thanks,

Ed Holloman

 

[til]

Code completion also should let you chose between the overloaded versions. At the Moment it just assumes the Parameters of the first function or procedure.

 

[Marco Kalter]

The parameters of the first overloaded procedure or function are displayed by default. However, the Code Assistant has a little overload selector at the lower left of the list. The selected overloading will be displayed again for subsequent parameters.