clarification of previous post: error '80040e14' ORA-06550: line 1, column 7: PLS-00
When trying to login using a valid userid and password we get the following information.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'VALIDATEUSER' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
/validate.asp, line 124
login.asp
<%@LANGUAGE="VBSCRIPT" @ENABLESESSIONSTATE=TRUE%>
<% Option Explicit %>
<!-- #INCLUDE FILE="adovbs.inc" -->
<!-- #INCLUDE FILE="ofacdefs.inc" -->
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" content="text/html">
<TITLE>Specify Options</TITLE>
<!-- ProcessButton() - Determines whether "Download excel" or "View Records" was selected. -->
<!-- Also uses the detect_width image to determine the current horizontal-->
<!-- frame size which is then passed on to the next page. -->
<script language="javascript">
<!-- begin
var firstClickTime = 0;
var docAction;
function ProcessButton(val)
{
if (firstClickTime == 0)
{
var firstClickDate = new Date(); // current date & time
firstClickTime = firstClickDate.getTime() // MILLISECONDS since Jan. 1, 1970
docAction = document.Vallogin.action;
if (val == 1)
{
document.Vallogin.action = "validate.asp";
document.Vallogin.submit();
return;
}
else
if (val == 2)
{
document.Vallogin.action = document.Vallogin.action + "/default.asp";
document.Vallogin.submit();
return;
}
}
else
validate.asp
Validateuser calls a stored procedure -
<%FUNCTION ValidateUser()
' call an Oracle stored procedure to validate the user
Set m_MyUserIDCommand.ActiveConnection=Cn
m_MyUserIDCommand.CommandType=adCMDStoredProc
m_MyUserIDCommand.CommandText="OfacResultSets.ValidateUser"
Set m_QueryInputParm1 = m_MyUserIDCommand.CreateParameter("Userid",adVarChar,adParamInput,9)
m_MyUserIDCommand.Parameters.Append m_QueryInputParm1
m_MyUserIDCommand("Userid")=m_UserID
Set m_QueryInputParm2 = m_MyUserIDCommand.CreateParameter("UserPW",adVarChar,adParamInput,9)
m_MyUserIDCommand.Parameters.Append m_QueryInputParm2
m_MyUserIDCommand("UserPW")=m_UserPW
Set m_QueryOutputParm1 = m_MyUserIDCommand.CreateParameter("Retval",adInteger,adParamOutput)
m_MyUserIDCommand.Parameters.Append m_QueryOutputParm1
Set m_QueryOutputParm2 = m_MyUserIDCommand.CreateParameter("gracelogs",adInteger,adParamOutput)
m_MyUserIDCommand.Parameters.Append m_QueryOutputParm2
Set m_QueryOutputParm3 = m_MyUserIDCommand.CreateParameter("UsName",adVarChar,adParamOutput,50)
m_MyUserIDCommand.Parameters.Append m_QueryOutputParm3
Set m_QueryOutputParm4 = m_MyUserIDCommand.CreateParameter("pwexpires",adInteger,adParamOutput)
m_MyUserIDCommand.Parameters.Append m_QueryOutputParm4
Set m_QueryOutputParm5 = m_MyUserIDCommand.CreateParameter("UsAdmin",adInteger,adParamOutput)
m_MyUserIDCommand.Parameters.Append m_QueryOutputParm5
m_MyUserIDCommand.Execute()
Line 124 is the above execute command.
I am using:
1) Microsoft ODBC Driver for Oracle V2.573.3711.00
2) Oracle V7.3.4.2.0
3) NT 4.0
The production version of this works fine, our development server lost the C partition and we built another server. Data in the tables exist via SQL plus, stored procedures exist when selecting the following:
SQL> select * from dba_source where name like 'OFACRESULTS%';
Any suggestions would greatly be appreciated.