Bug in the object browser

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).]
 
Overloaded program units are indeed displayed once in the Object Browser. Subsequent actions (Describe, Test) allow you to select a specific overloading though.

------------------
Marco Kalter
Allround Automations
 
I noticed, but since here we have a function and a procedure, it seemed kind of strange to me. Also, when I type desc str in the command window, it just displays the function, not the procedure. Different behaviour from SQL*Plus. Any particular reason for that?

------------------
Check out: http://www.oracledeveloper.nl
 
Back
Top