executing a stored function via OCI

From: Thomas Roner <Thomas.Roner_at_btv.at>
Date: Thu, 11 Nov 1999 13:23:33 +0100
Message-ID: <80eck6$kk9$1_at_apans1.apa.at>

Is it possible to execute a stored function with an in and one out parameter via OCI? I'm using the OCIClasses from www.codeguru.com

cur.Parse("begin :result := computeratio( :sampleid ); end;");

 cur.BindFloat(1, &sampleid);
 cur.BindFloat(2, &result);

I consider that there's something wrong with binding because I can execute stored procedures without parameters in this way without problems

I also tried to invoke the function in a SELECT-Statement but this doesn't work because I use Dynamic SQL in this function ..

Can anybody help me ????
Thanx
Tom Received on Thu Nov 11 1999 - 13:23:33 CET