Home » SQL & PL/SQL » SQL & PL/SQL » recreate a procedure
recreate a procedure [message #8166] Wed, 30 July 2003 21:53 Go to next message
pr
Messages: 4
Registered: December 1999
Junior Member
I have this procedure in my database. I made a change to the Insert statement and would like to recreate the procedure.

CREATE PROCEDURE change_insert
IS
BEGIN
INSERT INTO theatres VALUES (35, ‘Riverplace Theatre’, ‘1222 River Drive’, Austin, Tx.’);
END;
/

Can someone please tell me which of the 4 commands I would use now to prevent getting an error message
UPDATE PROCEDURE WITH
REPLACE PROCEDURE
CREATE OR REPLACE PROCEDURE
DELETE PROCEDURE

Thanks

Report message to a moderator

Re: recreate a procedure [message #8167 is a reply to message #8166] Wed, 30 July 2003 23:14 Go to previous message
Friend
Messages: 33
Registered: January 2002
Member
Use CREATE OR REPLACE PROCEDURE

Report message to a moderator

Previous Topic: Code not compiling - Any suggestion?
Next Topic: Help with user-defined function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 23:46:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.