Hi , a small question. How will you see the scripts of stored procedure which has been created already.
Is it like
Select from user_objects?
thanks,
satheesh
Printable View
Hi , a small question. How will you see the scripts of stored procedure which has been created already.
Is it like
Select from user_objects?
thanks,
satheesh
No, for source code of PL/SQL objects look at USER_SOURCE (ALL_SOURCE/DBA_SOURCE).
Something like:
SELECT text FROM dba_source
WHERE owner = 'USER_A' AND type = 'PROCEDURE' AND name = 'PROCEDURE_A'
ORDER BY line;
HTH,