syntax error with CFSTOREDPROC

New Here ,
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

Views

169

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 06, 2017 Feb 06, 2017

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines