Problem executing stored procedure with table parameters...

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
rpgkaiser
Posts: 4
Joined: Tue 09 Oct 2007 13:35

Problem executing stored procedure with table parameters...

Post by rpgkaiser » Tue 09 Oct 2007 14:37

Hi, i have the following oracle scenario (simplified, of course):

- A table type named t_strings inside a package named globals.
- A stored procedure named all_emps inside a package named employees, who has an out parameter of type t_strings:

procedure all_emps(names out globals.t_strings);

In C# i try to execute the stored proc all_emps in this way:

OracleCommand cmd = this.connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "employees.all_emps";
OracleParameter param = new OracleParameter("names",
OracleDbType.Table);
param.Direction = ParameterDirection.Output;
param.ObjectTypeName = "globals.t_strings";
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();

The execution end with an exception with message:
"OCI-22303: type "GLOBALS"."T_STRINGS" not found"

an i already verify than the t_strings table type exist.

Is this an know problem? There is any problem with the execution of stored procedure with table parameters, specifically when the table type is inside a package?
Please help me. A have make many search over the internet an i have no track about this issue.

PD: I'm using OraDirect .NET Data Provider 3.50.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 10 Oct 2007 06:59

First of all, use the latest version of OraDirect .NET (3.55).
Do you use direct mode? What is the version of your Oracle server?
Please provide the definition of your database objects.

Post Reply