Re: Records Not Being Updated in Stored Procedures

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/04/12
Message-ID: <38f9f8c1.32807424@netnews.worldnet.att.net>#1/1

Are you comitting yoru transaction?

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Wed, 12 Apr 2000 12:35:55 -0700, Adam Lassy <adam_at_egmail.com> 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;
>/
Received on Wed Apr 12 2000 - 00:00:00 CDT