| spool procedure text [message #197860] |
Thu, 12 October 2006 23:54  |
oracle_coorgi
Messages: 188
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  |
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 ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
