Re: How to modify an stored procedure ?

From: Balakrishna Avula <100610.52_at_compuserve.com>
Date: 1996/04/26
Message-ID: <4lq4mm$iln_at_relay1.mdis.com>#1/1

>I want to modify an existing stored procedure, how can I get a copy of it and
>modify it?

>Thanks in advance,
>Duffy

Get the source of procedural objects from user_source/all_source/dba_source views and once the new code is written CREATE OR REPLACE option can be used to replace old objects with new code.

Hope this helps.

Bala

--
Balakrishna Avula						28 Ashby Court
Alpha-Tek Associates Ltd.					Hemel Hempstead
Technical Consultant(on contract to Oracle UK)			HERTS HP2 7QL
100610,52 on Compuserve						UK

Received on Fri Apr 26 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: txu_at_softart.com: "Question on 32 bit client"
Previous message: Tim Jinkerson - Sun UK - Applications Engineer: "Re: How to modify an stored procedure ?"
In reply to: MCC: "How to modify an stored procedure ?"
In reply to MCC: "How to modify an stored procedure ?"
Next in thread: Simone B. Garcia Costa: "Re: Problems with CHARs in v7.1.6"
Reply: Yoram zilberberg: "Re: How to modify an stored procedure ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message