In short : I don't know how to get returned object from the jdbc 'func' .
Hi,
I'm kind of desesperated, if anybody could help, or link to help:
This is some java-jdbc code:
//cn is my connexion
String query = "{? = call AAATest.FTest(3)}";
csload = (OracleCallableStatement)cn.prepareCall(query);
csload.registerOutParameter(1, OracleTypes.NUMBER);
csload.executeQuery();
java.sql.Struct st = (java.sql.Struct)csload.getObject(1);
I want to do the same in perl:
my $query = '{? = call AAATest.FTest(3)}';
my $ret = $dbh->func(query, "jdbc_prepareCall");
this works, but returns a string, not a statement object that I could reuse.
The string looks like 'oracle.jdbc.driver.OracleCallableStatement@d225a7'
I would like to know if I could build a statment object from this string, and
if not, how do I get the returned statment object? So that I can call func on
it.
Thanx
