Unable to describe a procedure in a package

[achada]

Hi --

I am having trouble describing a procedure in a package.

that is

SQL>DESC PACKAGE1.PROCEDURE1;

i am getting ORA-04043: object PACKAGE1.PROCEDURE1 does not exist,
but i am able to execute the procedure
that is
SQL> exec PACKAGE1.PROCEDURE1;

I am just wondering why can't i describe it when i am able to execute it.

Any ideas

Thanks

[sreddy]

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.

[Oracledba8]

Hi,

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.

Desc mypackage

Thanks

[achada]

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.

for example:

SQL> DESC package1.procedure1;
SQL>
Name Datatype Required
---------------- ------------ -------------
parameter1 date yes
parameter2 varchar2 No


I could be wrong.

Thanks

[PSoni]

I studied
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.


P Soni

[sreddy]

It works in SQL*Plus 8 also...

[akkerend]

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).

[sreddy]

You can