-
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
Anil Chada
-
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.
Reddy,Sam
-
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
-
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
Anil Chada
-
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
-
It works in SQL*Plus 8 also...
Reddy,Sam
-
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).
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|