I get the following error when I invoke a cfcomponent which has a cffunction that calls a stored procedure:
Here is the fault returned when invoking the web service operation:
AxisFault
faultCode: {
http://xml.apache.org/axis/}HTTP
faultSubcode:
faultString: (500)Internal Server Error
faultActor:
faultNode:
faultDetail:
{}:return code: 500
{
http://xml.apache.org/axis/}HttpErr
orCode:500
The error occurred in C:\CFusionMX7\wwwroot\acco
untInforma
tion.cfm: line 54
52 : <cfinvoke webservice="
http://LOCALHOST/component_lookup1a.cfc?wsdl" method="getAcctInfo" returnvariable="rst1">
53 : <cfinvokeargument name="acct_id" value="#v_acct_ID#">
54 : <cfinvokeargument name="premID" value="#v_prem_id#">
55 : </cfinvoke>
Here is the component
<cfcomponent>
<cffunction name = "getAcctInfo" access="remote" returntype="query">
<cfargument name= "acct_id" required = "true" displayname="acct_id" >
<cfargument name = "premID" required = "true" displayname="premID">
<cfstoredproc procedure= "acctLookup2" datasource= "CFDM">
<cfprocparam type= "In" cfsqltype= "CF_SQL_CHAR" value= "#arguments.acct_id#" null="no">
<cfprocparam type= "In" cfsqltype= "CF_SQL_CHAR" value= "#arguments.premID#" null="no">
<cfprocparam type= "OUT" cfsqltype= "CF_SQL_CHAR" null="no" variable = "p_acct_id">
<cfprocparam type= "OUT" cfsqltype= "CF_SQL_CHAR" null="no" variable = "p_address">
<cfprocparam type= "OUT" cfsqltype= "CF_SQL_CHAR" null="no" variable = "p_city">
<cfprocparam type= "OUT" cfsqltype= "CF_SQL_CHAR" null="no" variable = "p_postal">
<cfprocresult name= "acctLookup" resultset="rst1">
</cfstoredproc>
<cfreturn rst1>
</cffunction>
</cfcomponent>
Here is the stored procedure:
CREATE OR REPLACE procedure acctLookup2(
p_acct_num in varchar2,
p_premID in varchar2,
p_acct_id out varchar2,
p_address out varchar2,
p_city out varchar2,
p_postal out varchar2)
as
Begin
SELECT ACCT_ID, ADDRESS1, CITY, POSTAL
into p_acct_id, p_address, p_city, p_postal
FROM V_ACCOUNT_INFO_FAST
WHERE acct_id = p_acct_num
AND PREM_ID = p_premID;
End ;
Please help