Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with PL/SQL stored procedure
On Tue, 26 Jun 2001 19:48:39 +0530, "Ramya" <priya.ramya_at_blr.spcnl.co.in> wrote:
>Hello,
> I face the following problem with PL/SQL stored procedures. The Oracle
>version is 8.0.5 on Windows NT 4
>The stored procedure is triggered from VC++ executable. If for some reason,
>an exception is caught in the stored procedure (like no_data_found
>exception), then the following problem occurs.
>If we try to trigger the stored procedure again through the VC++ executable,
>the variables in the stored procedures have the values as in the previous
>execution. They are not getting initialised. (The same database connection
>is used in VC++ executable).
>Currently, only if a new connection to the database is used , the problem is
>solved.
>
>What could be the reason for this problem and how can this be corrected?
>
>Please send in your suggestions.
>
>Thanks and Regards,
>Ramya Priya
>
>
Please provide the code of your stored procedure in order for us to help you.
Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com
Received on Sat Jun 30 2001 - 08:23:56 CDT