Re: Invalid character???

"Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> wrote:

>JDBC docs suggest otherwise and your syntax does not look correct:
>assignment to the return variable should precede the CALL keyword, not
>follow it (" ?= call <procname>", not "call ?= <procname>" as in your
>example.)

Oh geez, you're right, of course. My typing here was sloppy. I do have it correct in the code: { call ? := getReporterData(?) }

> Anyway, which statement throws the error? prepareCall() or
>execute(), or maybe one of the binds? I don't see where you declare
>sprocStmt either - is it a CallableStatement or an
>OracleCallableStatement? And what's the function prototype? Is it's
>argument indeed a VARCHAR2?

execute throws the error. I've never heard of "OracleCallableStatement", the examples I've seen use "CallableStatement", and that's what sprocStmt is.

I just tried "OracleCallableStatement" in my code. Now when I call the PrepareStatement method of the connection object, I get told that it's returning the wrong thing, namely a CallableStatement object that it's trying to stuff into an OracleCallableStatement object.

The argument to getReporterData is char.

>You see, my crystal ball is malfunctioning lately, so the more input
>you give, the more chances there are we will be able to help you
>pinpoint the source of the problem and fix it.

Absolutely, I've said the same to many posters in other groups (where I actually have a clue as to the subject matter)!

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