Re: C (embedded SQL) : receive boolean out-parameter of a stored procedure

"bernhard labus" <bernhard.labus_at_home.ins.de> wrote in message news:3bbc6084$0$231$4d4ebb8e_at_businessnews.de.uu.net...
> Hallo,
>
> does anybody know, how to handle this:
>
> - given:
> a stored procedure with out parameter boolean or
> function return boolean, e.g.
> procedure bool_bla (out_bool out boolean) or function bool_bla return
> boolean ..
>
> - wanted:
> call the procedure/function in C (embedded sql), e.g.
> exec sql execute
> begin
> :mybool := bool_bla; or bool_bla(:mybool);
> end;
> end-exec;
>
> - needed:
> ? How declare "mybool", the C-variable to hold the boolean value?
> returned from the stored procedure
> Server-System is Oracle-RDBMS 7.3.4, Pro*C 2.2.4.0.0
>
> Have browsed through oracle-technet and dejanews, found nothing,
> except (funny) example with function "sal_ok" return boolean,
> created from C, but no call/execute explained.
>
> Thanx, Bernhard
>
>

Boolean is an *internal* pl/sql datatype *only* You need to replace the out parameter by a CHAR or a NUMBER.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 04 2001 - 12:30:44 CDT