Re: Records Not Being Updated in Stored Procedures

Try issuing a commit in right after the Insert statement. I believe DDL statements commit transactions to the database so that is why you can see it after you re-create the procedure. You should still be able to see the record within the same session regardless if you issue a commit or not.

Kyriakos Lambros
Programmer
Las Vegas Valley Water District

Adam Lassy wrote:

> 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