Re: Invalid character???
Date: 18 Aug 2008 14:40:27 -0800
Message-ID: <48a9ec4b$1@news.victoria.tc.ca>
Tim Slattery (Slattery_T_at_bls.gov) wrote:
: 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?
What are the { } braces for in the SQL statement ? Received on Mon Aug 18 2008 - 17:40:27 CDT