3 Replies Latest reply on Aug 3, 2016 7:11 AM by WolfShade

    Coldfusion Standard and Stored Procedure

    Golem

      Hi, I would like to know if Oracle stored procedure are supported in Coldfusion 2016 Standard (exept for reference cursors).

       

      I try to call a simply stored procedure like this:

      CREATE OR REPLACE PROCEDURE MYDATABASE.TEST_PROC

      ( FIRSTNAME IN VARCHAR2,

      LASTNAME IN VARCHAR2,

      FULLNAME OUT VARCHAR2)

      AS

      BEGIN

        FULLNAME := FIRSTNAME || '  ' || LASTNAME;

      END;

      /

       

      With this coldfusion code:

      <cfstoredproc procedure="TEST_PROC" datasource="mydatasource" returncode="No">

         <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FIRSTNAME" value="John">

        <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":LASTNAME" value="Doe">

        <cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FULLNAME" variable="fullname">

      </cfstoredproc>

       

      But I receive this error:

      ErrorCode 17041

      Message Missing IN or OUT parameter at index:: 4

       

      Anyone can help me?