patch
Member³
I have a package like this in the database:
CREATE OR REPLACE PACKAGE str
IS
FUNCTION betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER )
RETURN VARCHAR2;
PROCEDURE betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER, string_out OUT VARCHAR2 );
END str;
/
CREATE OR REPLACE PACKAGE BODY str
IS
FUNCTION betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER )
RETURN VARCHAR2
IS
BEGIN
RETURN( SUBSTR( string_in, start_in, end_in - start_in + 1 ));
END betwn;
PROCEDURE betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER, string_out OUT VARCHAR2 )
IS
BEGIN
string_out := SUBSTR( string_in, start_in, end_in - start_in + 1 );
END betwn;
END str;
/
When I click on the functions folder in the object browser, it displays betwn.
However, when I click on the procedures folder in the object browser, it displays nothing.
Also, wrong-click str and select describe will only show me the function.
If I type 'desc str' in a command window, it also only displays the function. If I type 'desc str' in a SQL*Plus session, then it displays both the function and the procedure (including the parameters).
I think this might be a bug (probably also in DOA?!?).
By the way, I'm using 5.1.1.672
------------------
Check out: http://www.oracledeveloper.nl
[This message has been edited by patch (edited 29 April 2003).]
CREATE OR REPLACE PACKAGE str
IS
FUNCTION betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER )
RETURN VARCHAR2;
PROCEDURE betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER, string_out OUT VARCHAR2 );
END str;
/
CREATE OR REPLACE PACKAGE BODY str
IS
FUNCTION betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER )
RETURN VARCHAR2
IS
BEGIN
RETURN( SUBSTR( string_in, start_in, end_in - start_in + 1 ));
END betwn;
PROCEDURE betwn( string_in IN VARCHAR2, start_in IN PLS_INTEGER, end_in IN PLS_INTEGER, string_out OUT VARCHAR2 )
IS
BEGIN
string_out := SUBSTR( string_in, start_in, end_in - start_in + 1 );
END betwn;
END str;
/
When I click on the functions folder in the object browser, it displays betwn.
However, when I click on the procedures folder in the object browser, it displays nothing.
Also, wrong-click str and select describe will only show me the function.
If I type 'desc str' in a command window, it also only displays the function. If I type 'desc str' in a SQL*Plus session, then it displays both the function and the procedure (including the parameters).
I think this might be a bug (probably also in DOA?!?).
By the way, I'm using 5.1.1.672
------------------
Check out: http://www.oracledeveloper.nl
[This message has been edited by patch (edited 29 April 2003).]