Re: Invalid character???

yf110_at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:

>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 ?

That's JDBC syntax, it's not the problem.

<Sigh>....the java folks thought maybe the colon before the equal sign was the problem. That's not it either.

-- 
Tim Slattery
Slattery_T_at_bls.gov
http://members.cox.net/slatteryt