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

From: bernhard labus <bernhard.labus_at_home.ins.de>
Date: Thu, 4 Oct 2001 15:16:05 +0200
Message-ID: <3bbc6084$0$231$4d4ebb8e@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 Received on Thu Oct 04 2001 - 08:16:05 CDT