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

syntax error with CFSTOREDPROC

New Here ,
Feb 01, 2017 Feb 01, 2017

<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

295
Translate
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

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

Cheers

Eddie

Translate
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
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.

Translate
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