Calling an Oracle Stored Procedure
- From: Carol K <CarolK@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 06:08:00 -0800
When I call a stored procedure from my app, I recieve the following message
ORA-06550: line1, Column 7:
PLS-00801: internal error [22503]
The code is ...
OracleCommand^ UserPassCmd = gcnew
OracleCommand("UNIX_PACK.VERIFY_ID(log_name, inuserpasswd, inapplid,
outuserid, outuserpasswd, outrc, outmess)",NestConnection);
UserPassCmd->CommandType = CommandType::StoredProcedure;
OracleParameter^ parmlog_name =
UserPassCmd->Parameters->Add("log_name",OracleType::VarChar,USER_PASS);
parmlog_name->Direction = ParameterDirection::Input;
parmlog_name->Value = log_name;
OracleParameter^ parminuserpasswd =
UserPassCmd->Parameters->Add("inuserpasswd",OracleType::VarChar,USER_PASS);
parminuserpasswd->Direction = ParameterDirection::Input;
parminuserpasswd->Value = "Passwd";
OracleParameter^ parminapplid =
UserPassCmd->Parameters->Add("inapplid",OracleType::VarChar,USER_PASS);
parminapplid->Direction = ParameterDirection::Input;
parminapplid->Value = "Generic Apps";
OracleParameter^ parmoutuserid =
UserPassCmd->Parameters->Add("outuserid",OracleType::VarChar,USER_PASS);
parmoutuserid->Direction = ParameterDirection::Output;
OracleParameter^ parmoutuserpasswd =
UserPassCmd->Parameters->Add("outuserpasswd",OracleType::VarChar,USER_PASS);
parmoutuserpasswd->Direction = ParameterDirection::Output;
OracleParameter^ parmoutrc =
UserPassCmd->Parameters->Add("outrc",OracleType::Int16);
parmoutrc->Direction = ParameterDirection::Output;
OracleParameter^ parmoutmess =
UserPassCmd->Parameters->Add("outmess",OracleType::VarChar,TEXT_LINE);
parmoutmess->Direction = ParameterDirection::Output;
UserPassCmd->ExecuteNonQuery();
This stored procedure executes without issues from an Oracle Forms app.
Thanks
Carol K
.
- Prev by Date: Re: Documentation for C++ classes supportint the ActiveX ADO contr
- Next by Date: SQL Error messages missing in ADO
- Previous by thread: Re: Documentation for C++ classes supportint the ActiveX ADO controls?
- Next by thread: SQL Error messages missing in ADO
- Index(es):
Relevant Pages
|
