Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Records Not Being Updated in Stored Procedures
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.4037Received on Wed Apr 12 2000 - 00:00:00 CDT
![]() |
![]() |