================================
PROCEDURE dlc_mail_countMsg (
studentID IN number,
mailInfo OUT types.cursorType
)
AS
BEGIN
OPEN mailInfo FOR
SELECT
count(*) AS msgCount
FROM
tblMail
WHERE
mIndividID = studentID AND
mToType = 1 AND
mRecipActive = '1' AND
mRead IS NULL;
END dlc_mail_countMsg;
================================
...and this CFSTOREDPROC call:
================================
<cfstoredproc datasource="DLCampus" procedure="dlc.dlc_mail_countMsg">
<cfprocparam type="in" value="#cookieID#" cfsqltype="cf_sql_integer">
<cfprocresult name="msgCount">
</cfstoredproc>
================================
...and, finally, this error message:
================================
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'DLC_MAIL_COUNTMSG' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
================================
In tblMail, the datatypes are:
mIndividID number
mToType number
mRecipActive char(1)
mRead date
I can't see the error. It looks like all of the paramters are being
passed, and nothing unusual is going on. I've Googled but couldn't find
anything that looks relevant.
Anyone have any ideas?
--
Richard S. Crawford
Programmer III,
UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
(916)327-7793 / [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
