Re: Invalid character???
Date: Wed, 20 Aug 2008 13:35:25 -0400
Message-ID: <b7loa4hno2b9ajsn3k65fslbhmg27t91tb@4ax.com>
Tim Slattery <Slattery_T_at_bls.gov> wrote:
>Laurenz Albe <invite_at_spam.to.invalid> wrote:
>
>>They have two samples:
>>
>>// SQL-92 syntax
>>conn.prepareCall("{? = call func (?,?)}");
>>
>>// PL/SQL anonymous block
>>conn.prepareCall("begin ? := func(?,?); end;");
>
>I've tried both, I get illegal character from the first and something
>about illegal type from the second. Neither works.
A tiny bit of progress. My statement now reads:
{ ? = call getReporterData(?) }
No colon, and the "call" is right before the function name. Now it blows up when I call the "getObject" method of CallableStatement, after the "execute" method has run.
sprocStmt.registerOutParameter(1, OracleTypes.CURSOR); sprocStmt.setString(2, key);
sprocStmt.execute(); ResultSet result = (ResultSet)sprocStmt.getObject(1);
Localized message: [BEA][Oracle JDBC Driver]The requested output
parameter data is not available.
SQL State: HY000
Error code: 0
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Wed Aug 20 2008 - 12:35:25 CDT