Copy link to clipboard
Copied
<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
Copy link to clipboard
Copied
What is the data type of the value that you are returning from your stored procedure?
Cheers
Eddie
Copy link to clipboard
Copied
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.