Here is an example function spec from the package. No output parameters
listed.
FUNCTION GET_CONTENT_FILE_STATUS_ID(
I_CFSREF_ALPHA_CODE
CONTENT_FILE_STATUS_REF_TB.CFSREF_ALPHA_CODE%TYPE
) RETURN
CONTENT_FILE_STATUS_REF_TB.CFSREF_CONTENT_FILE_STATUS_ID%TYPE;
-----Original Message-----
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 11:55 AM
To: CF-Talk
Subject: ***SPAM*** Re: Stored procedures
here's how ya get at a fucntion that is part of a package:
<cfstoredproc procedure="schemaName.packageName.functionName"
datasource="#datasource#" username="#userid#" password="#passwd#">
<cfprocparam type="In" cfsqltype="CF_SQL_BIGINT" dbvarname="varName1"
value="varValue1">
<cfprocparam type="In" cfsqltype="CF_SQL_BIGINT" dbvarname="varName2"
value="varValue2">
<cfprocparam type="Out" cfsqltype="CF_SQL_BIGINT" dbvarname="DBoutVarName"
variable="outVarName">
</cfstoredproc>
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238661
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
