I am having trouble describing a procedure in a package.
i am getting ORA-04043: object PACKAGE1.PROCEDURE1 does not exist,
but i am able to execute the procedure
SQL> exec PACKAGE1.PROCEDURE1;
I am just wondering why can't i describe it when i am able to execute it.
I didn't understand your Q. What do you mean by DESC a package ? You wanna see the source or what ?
You can use DBA_SOURCE view and select text column for that, if thats what you wanted.
You can describe any object with in a package, but you can describe the Package itself, it will give you all the objects and parametrs etc.
As far as i remember when you describe a procedure or a function or a package.procedure
oracle will show the parameter name, data type and required or not.
SQL> DESC package1.procedure1;
Name Datatype Required
---------------- ------------ -------------
parameter1 date yes
parameter2 varchar2 No
I could be wrong.
It is working when Using SQL Plus 3.3
But it is giving error in SQL Plus 8
Trying to find out if any thing.
It works in SQL*Plus 8 also...
There is a difference between SQL*Plus 3.3 and 8.0.
In SQL*Plus 3.3 you can describe subobjects (like procedures in packages), in 8.0 you can only describe objects (not procedures in packages).
Click Here to Expand Forum to Full Width