0
syntax error with CFSTOREDPROC
New Here
,
/t5/coldfusion-discussions/syntax-error-with-cfstoredproc/td-p/8824086
Feb 01, 2017
Feb 01, 2017
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
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Advocate
,
/t5/coldfusion-discussions/syntax-error-with-cfstoredproc/m-p/8824087#M175032
Feb 02, 2017
Feb 02, 2017
Copy link to clipboard
Copied
What is the data type of the value that you are returning from your stored procedure?
Cheers
Eddie
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more
Community Expert
,
LATEST
/t5/coldfusion-discussions/syntax-error-with-cfstoredproc/m-p/8824088#M175033
Feb 06, 2017
Feb 06, 2017
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.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
Learn more

