Re: Invalid character???

From: Tim Slattery <Slattery_T_at_bls.gov>
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/slatteryt
Received on Wed Aug 20 2008 - 12:35:25 CDT

Original text of this message