Invalid character???
From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Mon, 18 Aug 2008 16:23:08 -0400
Message-ID: <k9mja4tf1dblouihhh68jb4cagc0r5onf7@4ax.com>
Date: Mon, 18 Aug 2008 16:23:08 -0400
Message-ID: <k9mja4tf1dblouihhh68jb4cagc0r5onf7@4ax.com>
I'm at a total impasse. I have a stored function that returns a
SYS_REFCURSOR. It works fine, I can call it in SQL*Plus and see the
data that's been extracted. I'm trying to call it from Java:
String spName; try { getDBConnection(); /* sets "dbConnection */ spName = "{ call ? := getReporterData(?) }"; sprocStmt = dbConnection.prepareCall(spName); sprocStmt.registerOutParameter(1, OracleTypes.CURSOR); sprocStmt.setString(2, key); sprocStmt.execute();
And I get ORA-00911 Invalid character. What invalid character?
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Mon Aug 18 2008 - 15:23:08 CDT