Hello again,

Need some help bad with the following. Oracle 9.2 have following stored proc

CREATE OR REPLACE PROCEDURE Decrypt(UserName VARCHAR2,
                                p_decrypted_string OUT VARCHAR2)
                                 
                          
    IS
     key_string          VARCHAR2(8)  := 'scottsco';
     encrypted_string    VARCHAR2(2048);
     decrypted_string    VARCHAR2(2048);
     
   BEGIN
    select u_password into encrypted_string
     from Table1
     where F_Name = UserName;
   
     dbms_obfuscation_toolkit.DESDecrypt(
                      input_string => encrypted_string, 
                      key_string => key_string, 
                      decrypted_string => decrypted_string);
              
     p_decrypted_string := decrypted_string;  
           
   END;

If I run this looks good.

Now I have my asp code as follows to try and connect and retrieve value

UserName = request.Form("login")
 
oConn.Open
oCmdUserInfo.ActiveConnection = oConn
oCmdUserInfo.CommandType = adCmdStoredProc
oCmdUserInfo.CommandText = "decrypt"

 oCmdUserInfo.Parameters.Append oCmdUserInfo.CreateParameter("UserName", adVarChar, adParamInput, 400, UserName)
 oCmdUserInfo.Parameters.Append oCmdUserInfo.CreateParameter("p_decrypted_string", adVarChar, adParamOutput, 8)
 Set objRsUser = oCmdUserInfo.Execute
 Test = oCmdUserInfo.Parameters("p_decrypted_string").value
 
If objRsUser.EOF Then
  Session("Authenticated") = 0
%>

I run this an keep getting a error at this line

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'DECRYPT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored 
/test/login.asp, line 111

 
Set objRsUser = oCmdUserInfo.Execute

I also have an include file adovbs.inc.
I or nobody can figure this out. Any ideas experts. Thanks.

I think it's your Test = line. If your sproc returns the data as a select statement, like table data, you won't be able to get it as an output parameter.

Learning Newbie,

Thanks for the response. I have removed the test = line and still receive the same error in Set objRsUser = oCmdUserInfo.Execute. Is there anyway to troubleshoot this? Thanks.

I'm not familiar with Oracle either (never used it before), but try this:

Set objRsUser = conn.Execute (oCmdUserInfo)

Nope same error. It's almost like a recordset is not being returned.

Originally Posted by HelpR

Hello again,

Need some help bad with the following. Oracle 9.2 have following stored proc

CREATE OR REPLACE PROCEDURE Decrypt(UserName VARCHAR2,
                                p_decrypted_string OUT VARCHAR2)
 
 
    IS
     key_string          VARCHAR2(8)  := 'scottsco';
     encrypted_string    VARCHAR2(2048);
     decrypted_string    VARCHAR2(2048);
 
   BEGIN
    select u_password into encrypted_string
     from Table1
     where F_Name = UserName;
 
     dbms_obfuscation_toolkit.DESDecrypt(
                      input_string => encrypted_string, 
                      key_string => key_string, 
                      decrypted_string => decrypted_string);
 
     p_decrypted_string := decrypted_string;  
 
   END;

If I run this looks good.

Now I have my asp code as follows to try and connect and retrieve value

UserName = request.Form("login")
 
oConn.Open
oCmdUserInfo.ActiveConnection = oConn
oCmdUserInfo.CommandType = adCmdStoredProc
oCmdUserInfo.CommandText = "decrypt"
 
 oCmdUserInfo.Parameters.Append oCmdUserInfo.CreateParameter("UserName", adVarChar, adParamInput, 400, UserName)
 oCmdUserInfo.Parameters.Append oCmdUserInfo.CreateParameter("p_decrypted_string", adVarChar, adParamOutput, 8)
 Set objRsUser = oCmdUserInfo.Execute
 Test = oCmdUserInfo.Parameters("p_decrypted_string").value
 
If objRsUser.EOF Then
  Session("Authenticated") = 0
%>

I run this an keep getting a error at this line

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'DECRYPT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored 
/test/login.asp, line 111
 
 
Set objRsUser = oCmdUserInfo.Execute

I also have an include file adovbs.inc.
I or nobody can figure this out. Any ideas experts. Thanks.

Did you resolved this problem ? I have the same problems now. I don't know what to do ?

Did you resolve this problem? I have the same problem now I don't know what to do.