Home » SQL & PL/SQL » SQL & PL/SQL » how to check the details of any function or procedure etc (Oracle 10g)
how to check the details of any function or procedure etc [message #608084] Sat, 15 February 2014 02:44 Go to next message
jgjeetu
Messages: 231
Registered: July 2013
Location: India Hindustan
Senior Member
I have one function name and one procedure name ,
now i have to check the description/body of this function
or procedure. how to do that please tell.
for exmaple as we do for tables "desc tablename" ,
Thanks
Re: how to check the details of any function or procedure etc [message #608086 is a reply to message #608084] Sat, 15 February 2014 03:20 Go to previous messageGo to next message
jgjeetu
Messages: 231
Registered: July 2013
Location: India Hindustan
Senior Member
./fa/11701/0/

ok so got the answer after doing some google research Cool , now can anybody please tell what
are name,type,text and line denotes here
on the basis of output i got some idea about these
but i want proper knowledge about these
Thanks
  • Attachment: Untitled.jpg
    (Size: 58.79KB, Downloaded 82 times)
Re: how to check the details of any function or procedure etc [message #608089 is a reply to message #608086] Sat, 15 February 2014 03:58 Go to previous messageGo to next message
Littlefoot
Messages: 19623
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's a book about that Spanish guy named Manual; you should read it.
Re: how to check the details of any function or procedure etc [message #608090 is a reply to message #608089] Sat, 15 February 2014 04:34 Go to previous messageGo to next message
jgjeetu
Messages: 231
Registered: July 2013
Location: India Hindustan
Senior Member
Thanks for the info but i got the same link when i searched "USER_SOURCE IN ORACLE" , bt
there is nothing given about these terms i.e text,name,type and line Razz
Re: how to check the details of any function or procedure etc [message #608092 is a reply to message #608090] Sat, 15 February 2014 04:47 Go to previous messageGo to next message
Littlefoot
Messages: 19623
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If that's your final answer, then I'm afraid that noone here can help you.
Re: how to check the details of any function or procedure etc [message #608097 is a reply to message #608092] Sat, 15 February 2014 05:49 Go to previous message
jgjeetu
Messages: 231
Registered: July 2013
Location: India Hindustan
Senior Member
name:=name of the object
type= type of object for ex. package,trigger,procedure etc
line=line number of this line of source
text=text source of the stored object.

Previous Topic: SELECT query gives error
Next Topic: how to search the package object_type from all_objects
Goto Forum:
  


Current Time: Fri Sep 19 21:17:34 CDT 2014

Total time taken to generate the page: 0.13473 seconds