Coldfusion Standard and Stored Procedure
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?
