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>
exception
when others return (sqlcode);
end;
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