• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

229

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

Votes

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
Community Expert ,
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.

Votes

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
Resources
Documentation