I've included my code this time. I'm sure it's something easy but I dont'
know what.
Thank you!
Scott Rowe
Oracle stored proc:
Create Procedure usercheck
(UserID IN NUMBER, TimeLastVisit OUT VarChar2)
AS
BEGIN
--check for a user--
Select To_Char(TimeLastVisit,'yyyy-mm-dd HH24:mi:ss')
INTO TimeLastVisit
FROM UsersLoggedIn
WHERE UserID = UserID;
EXCEPTION
When NO_DATA_FOUND
THEN TimeLastVisit := 0;
END;
<cfstoredproc datasource="fenics_new" procedure="UserCheck"
returncode="Yes">
<cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbvarname="UserID"
value="#Client.CFID#">
<cfprocparam type="Out" variable="TimeLastVisit"
cfsqltype="CF_SQL_DATE">
</cfstoredproc>
This is the error:
Oracle Error Code = 1036
ORA-01036: illegal variable name/number
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
