[Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored procedure call. Check your bindings against the stored procedure's parameters.
Here is my code
<cfstoredproc procedure="class_user_maint.in_grace" datasource="#dsn#" returncode="yes">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" value="#session.user#" null="no">
<cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" variable="Grace" null="no">
<cfprocparam type="Out" cfsqltype="CF_SQL_INTEGER" variable="TheDays" null="no">
</cfstoredproc>
And here is the SQL package with the stored procedure (it is the in_grace one)
/* Formatted on 2004/05/06 14:59 (Formatter Plus v4.8.0) */
CREATE OR REPLACE PACKAGE class_user_maint
IS
PROCEDURE change_password (
i_user IN VARCHAR2,
i_password IN VARCHAR2,
o_msg OUT VARCHAR2
);
PROCEDURE in_grace (
i_user IN VARCHAR2,
o_grace OUT VARCHAR2,
o_days OUT NUMBER
);
FUNCTION session_exists (i_user IN VARCHAR2)
RETURN VARCHAR2;
END class_user_maint;
/
Can someone please help me figure out what I need to do to get this to work?
Thank you very much.
Brian Yager
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
