Unable to describe a procedure in a package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Unable to describe a procedure in a package

  1. #1
    Join Date
    Mar 2001
    Posts
    3

    Exclamation

    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

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  3. #3
    Join Date
    Feb 2001
    Posts
    184
    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

  4. #4
    Join Date
    Mar 2001
    Posts
    3
    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

  5. #5
    Join Date
    Feb 2001
    Posts
    125
    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

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    It works in SQL*Plus 8 also...
    Reddy,Sam

  7. #7
    Join Date
    Jul 2000
    Posts
    296
    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).

  8. #8
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You can
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width