PL/SQL Block in Pro*C

From: Dogan Cibiceli <dcib_at_gwl.com>
Date: Fri, 18 Jun 1999 11:23:48 -0600
Message-ID: <376A80A4.636DAA90_at_gwl.com>

Hi,
[Quoted]   Rather pointless question but, suppose I have a PL/SQL block and I do :) What happens if one of the statements generate a data_not_found exception and I have no exception handler in my PL/SQL block in my Pro*C module. How much will rollback be done.? Will there be rollback ? The PL/SQL Block contains no procedures and no functions contains simple two sql statements and one PL/SQL conditional. Here's how it looks in big picture.

exec sql execute
declare

   my stuff ;
begin
  select from_tables
[Quoted]   into my_stuff

 if (sql%found) then

    if ( test dates )

       update table
  end if
 end if
end
exec sql end-exec

Thanks in adv.

D Received on Fri Jun 18 1999 - 19:23:48 CEST