Riste Pejov wrote:

> create procedure NEW_CONN (
> IP_ADDR varchar(15) character set ASCII)
> returns (
> CONN_ID numeric(18, 0))
>
> whitout a returning value i can execute it like this:
> st1->Prepare("EXECUTE PROCEDURE NEW_CONN '123.456.789.10'");
> st1->Execute();
>
> but I can't find a way to get the conn_id.

Use: SELECT conn_id FROM new_conn ...

And later:
st1->Fetch();
st1->Get(1, ...

You really should subscribe to ibpp-discuss mailing list at sourceforge
for further IBPP related questions.

--
Milan Babuskov
http://fbexport.sourceforge.net