Home » RDBMS Server » Server Administration » spool procedure text
spool procedure text [message #197860] Thu, 12 October 2006 23:54 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
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

thanxs

[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
gkrishn
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

DBMS_METADATA useful
'

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


Current Time: Mon Dec 05 15:08:54 CST 2016

Total time taken to generate the page: 0.20296 seconds