syntax error with CFSTOREDPROC

<CFSTOREDPROC PROCEDURE="create_reprice_decision"

DATASOURCE="#DSN#" returnCode="Yes" >

I'm running ColdFusion11, I have the above line, if i remove the returnCode="Yes", it is working. But it i leave it in, I'm getting the below error.

Error Executing Database Query. - [macromedia][Oracle JDBC Driver]Unhandled sql type

This topic has been closed for replies.

Community Expert

Looks like the driver cannot cope with the SQL type. What would the SQL type be, indeed? If everything is ordinary, then this could point to a bug.

Inspiring

What is the data type of the value that you are returning from your stored procedure?

Cheers

Eddie

Sign up