Hi,
When writing code, it really helps the "all" parameter option which automatically creates the parameter list for a procedure.
However it seems to pick the longest list when a procedure is overloaded.
eg:-
Package My_package
PROCEDURE proc1( a_ IN VARCHAR2);
PROCEDURE proc1( b_ IN VARCHAR2, c_ IN VARCHAR2);
so when I type in "My_package.proc1(" the visual "all" seems to add
My_package.proc1( b_ => ,
c_ => )
but it a bit misleading as there is also another that only needs a_.
Also is there a way to create such code without adding optional parameters? (parameters visible in the list enclosed in square brackets helps but on "all" it add them all and no way to find any of the added are optional or not).
My PLSQL Used was : Version 13.0.6.1911 (32 bit)
Thanks
Saka
When writing code, it really helps the "all" parameter option which automatically creates the parameter list for a procedure.
However it seems to pick the longest list when a procedure is overloaded.
eg:-
Package My_package
PROCEDURE proc1( a_ IN VARCHAR2);
PROCEDURE proc1( b_ IN VARCHAR2, c_ IN VARCHAR2);
so when I type in "My_package.proc1(" the visual "all" seems to add
My_package.proc1( b_ => ,
c_ => )
but it a bit misleading as there is also another that only needs a_.
Also is there a way to create such code without adding optional parameters? (parameters visible in the list enclosed in square brackets helps but on "all" it add them all and no way to find any of the added are optional or not).
My PLSQL Used was : Version 13.0.6.1911 (32 bit)
Thanks
Saka
Last edited: