Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: unable to edit procedures
Karnash wrote:
> When the procedures are loaded in TOAD they are unable to modify/edit
> it. That is the issue
Then stop using TOAD.
Do you have the source code? If so open it in vi or notepad and edit it. If not retrieve it:
SELECT DBMS_METADATA.GET_DDL('<object_type'>, '<object_name>') FROM dual;
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Aug 14 2007 - 10:22:48 CDT