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: How to compile store procedure without replacing the old one

Re: How to compile store procedure without replacing the old one

From: Bill Petty <pettyb_at_cadvision.com>
Date: 1997/05/13
Message-ID: <5lala5$25rs@elmo.cadvision.com>#1/1

Bob Yeh <tyeh_at_csc.com> writes: > Hi,
>
> I have been using sql*plus to compile my stored procedure by issuing:
> "create or replcae ..."
>
> Is ther a way to compile the source code without replacing the existing
> code?
>
> Thanks.
> Bob

Only by using a different name. There can only be one stored procedure using the name.

I'm not sure what you're trying to do here. Received on Tue May 13 1997 - 00:00:00 CDT

Original text of this message

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