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

Home -> Community -> Usenet -> c.d.o.tools -> Records Not Being Updated in Stored Procedures

Records Not Being Updated in Stored Procedures

From: Adam Lassy <adam_at_egmail.com>
Date: 2000/04/12
Message-ID: <38F4D01B.E689F694@egmail.com>#1/1

Hello - I have a stored procedure which inserts records into a database. I have found that, when executing the SP, the database does not show the changes until i reinitialize the procedure (or replace it). ie. ill run the procedure, but do not see that a new record was added to the database until i actually define the procedure again using the "create or replace" function below. is there something i am missing in my definition of the procedure or the way i call it? thanks

create procedure BYO_INSERT_CUSTOMER (temail IN varchar2) AS
BEGIN
        insert into Isuzu2k_Users_Personal(email) values (temail); END;
/

--
Adam Lassy
ANSWERTHINK
990 West 190th Street, Suite 400
Torrance, CA 90502

phone: 310.523.2000 x240
fax: 310.523.4037
Received on Wed Apr 12 2000 - 00:00:00 CDT

Original text of this message

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