MSDOTnet.org Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Calling an Oracle Store Procedure

 
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet
Author Message
Carol K



Joined: 08 Aug 2007
Posts: 1

PostPosted: Wed Nov 29, 2006 11:01 am    Post subject: Calling an Oracle Store Procedure Reply with quote

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

Archived from group: microsoft>public>dotnet>framework>odbcnet
Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
Oracle stored procedure - with more than one row? Hi: I am a newbie to accessing oracle stored procedures in C#. I have an oracle procedure that returns more than one row. I wanted to get the rows and store in a dataset in C# using I know how to do that for SQL server stored procedure u

Use Object type input parameter for oracle stored procedure My .NET application needs to communicate to a oracle stored procedure, which contains a object type input parameter. I could not find any way to add object typed parameter by either OracleClient or ODP.NET? Does any body know how to do this?

Enterprise Library 2006 - Calling Stored Procedure in DB2 How do you call a DB2 Stored Procedure??? Below is the latest that I have tried and it still fails. Any suggestions would be greatly appreciated. **** Code Sample & Error Message 'Set the Database to Connect to Dim db As Database =

Oracle using ASP.NET Hi All Can anyone help me with the following problem: I am trying to log onto an Oracle 8.0.5 database using ASP.NET running Oracle 8.1.7 Client. The application don't seem to find the created System DNS. Can anyone please HELP. I can connect to the DB us

About ADOX with Oracle Hi, I am trying to use ADOX to get the names of tables on certain Oracle Database. I did install Oracle Client first and its working fine. I made an instance from ADOX.Catalog object and I set the property to : ID=x
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group