Re: How to modify an stored procedure ?

duffy_at_cais.cais.com (MCC) wrote:
>I want to modify an existing stored procedure, how can I get a copy of it and
>modify it?
>

SQL> set linesize 132;
SQL> spool proc.prc
SQL> select text from user_source
SQL> where name = 'procedure_name';
SQL> spool off;

edit file proc.prc

proc.prc should consist of code for the required stored database procedure.

Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc. Received on Thu Apr 25 1996 - 00:00:00 CEST