Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: unable to edit procedures

Re: unable to edit procedures

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 14 Aug 2007 08:22:48 -0700
Message-ID: <1187104966.540894@bubbleator.drizzle.com>


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.org
Received on Tue Aug 14 2007 - 10:22:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US