2 Replies Latest reply on Feb 6, 2017 8:35 AM by BKBK

    syntax error with CFSTOREDPROC

    arunag53503483 Level 1

      <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