Re: Returning Error in Stored Procedures

From: Rom <orom_at_systec.com>
Date: Fri, 6 Jul 2001 20:00:11 -0400
Message-ID: <9i5jor0135p_at_enews2.newsguy.com>


function aaa ...
return number is

...
...
...

exception
when others return (sqlcode);
end;

Ofer.

Eddie <edward.anderson_at_impactinnovations.com> wrote in message news:dd288d7c.0107061104.7cdea236_at_posting.google.com...
> I was wondering if there was a way the I can return an error code from
> a stored procedure that I have in Oracle. I basically just call one
> insert statement in my stored procedure. I execute the store
> procedure from a Visual Basic Applicaiton. I didn't know if there was
> a way to do any Error Trapping for the successful execution of the
> store procedure and return this error code back to Visual basic.
>
> Eddie
Received on Sat Jul 07 2001 - 02:00:11 CEST

Original text of this message