Re: !!!Need help with stored pros

From: <martinj_at_pi.net>
Date: 1995/06/10
Message-ID: <NEWTNews.29853.802843053.martinj_at_pi-user.pi.net>#1/1


> I created a simple stored procedure that selects a count(*)
> from a table using a where clause. I then tested the value of
> the count to see if there is data or not. I am using SQL Plus
> to test the procedure. If the table has data or not,
> the procedure executed successfully.

I don't know if it's the answer, but maybe you should use :old and :new prefixes. Look in the manuals for the correct usage of those prefixes. Received on Sat Jun 10 1995 - 00:00:00 CEST

Original text of this message