First of all, thanks to all who have helped me on this site, I am forever greatful. I am near completion of my project and I couldn't have done it without you, especially you Carl.
I am trying to call a stored proc in Cold Fusion.
Here is my code:
<cfstoredproc procedure = "get_order_dups" datasource="#datasource#" username="#username#"
password="#password#" returnCode = "Yes">
<!--- cfprocresult tags --->
<cfprocresult name = RS1>
<!--- cfprocparam tags --->
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "GH45632" dbVarName = @param1>
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "JH43434" dbVarName = @param2>
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "B" dbVarName = @param3>
<cfprocparam type = "OUT" CFSQLType = CF_SQL_INTEGER
variable = 11_count dbVarName = @param4>
</cfstoredproc>
<cfoutput>
The output param value: ’#ll_count#’<br>
</cfoutput>
I am using Oracle as the database, and I am receiving this error:
The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
I am trying to call a stored proc in Cold Fusion.
Here is my code:
<cfstoredproc procedure = "get_order_dups" datasource="#datasource#" username="#username#"
password="#password#" returnCode = "Yes">
<!--- cfprocresult tags --->
<cfprocresult name = RS1>
<!--- cfprocparam tags --->
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "GH45632" dbVarName = @param1>
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "JH43434" dbVarName = @param2>
<cfprocparam type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "B" dbVarName = @param3>
<cfprocparam type = "OUT" CFSQLType = CF_SQL_INTEGER
variable = 11_count dbVarName = @param4>
</cfstoredproc>
<cfoutput>
The output param value: ’#ll_count#’<br>
</cfoutput>
I am using Oracle as the database, and I am receiving this error:
The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.