RE: Calling an Oracle Stored Procedure

Carol

Just looking at first sight

the error msg "ORA-06550: line1, Column 7: " indicates the stored proc which
you created contains error.So please rectify that and recompile the Stroed
proc and give it a try.

"Carol K" wrote:

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


.

Relevant Pages

  • Re: Calling an Oracle Stored Procedure
    ... outuserid, outuserpasswd, outrc, outmess)",NestConnection); ... OracleParameter^ parminuserpasswd = ... OracleParameter^ parmoutuserid = ...
    (microsoft.public.dotnet.framework.adonet)
  • Calling an Oracle Stored Procedure
    ... outuserid, outuserpasswd, outrc, outmess)",NestConnection); ... OracleParameter^ parminuserpasswd = ... OracleParameter^ parmoutuserid = ... This stored procedure executes without issues from an Oracle Forms app. ...
    (microsoft.public.data.ado)
  • Calling an Oracle Stored Procedure
    ... outuserid, outuserpasswd, outrc, outmess)",NestConnection); ... OracleParameter^ parminuserpasswd = ... OracleParameter^ parmoutuserid = ... This stored procedure executes without issues from an Oracle Forms app. ...
    (microsoft.public.dotnet.framework.adonet)