Skip to main content
arunag53503483
arunag53503483
Participating Frequently
Feb 1, 2017 10:46 PM UTC
Question

syntax error with CFSTOREDPROC

<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

This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
Feb 6, 2017 4:35 PM UTC

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
EddieLotter
EddieLotter
Inspiring
Feb 2, 2017 6:44 PM UTC

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

Cheers

Eddie

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices