Home » RDBMS Server » Server Administration » spool procedure text
spool procedure text [message #197860] Thu, 12 October 2006 23:54 Go to next message
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
how do i spool a procedure/function/package for or from a user say username=testname from the dict view i need to get package spec and body all other things total content
id dba_source , DBMS_METADATA useful


[Updated on: Fri, 13 October 2006 00:30]

Report message to a moderator

Re: spool procedure text [message #197888 is a reply to message #197860] Fri, 13 October 2006 02:20 Go to previous messageGo to next message
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
spool viewtext.txt
SELECT text FROM dba_source
WHERE name=<'name of procedure'> and and owner=<'owner name'> and type='PROCEDURE';
spool off

Is this what your requirement ?
Re: spool procedure text [message #198037 is a reply to message #197860] Sat, 14 October 2006 00:46 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


Yes it is useful..
Previous Topic: Best practices for implementing schema changes
Next Topic: Internal error during export
Goto Forum:

Current Time: Wed Oct 26 16:30:40 CDT 2016

Total time taken to generate the page: 0.26407 seconds