OraDirect not receive information about type from package...is this true??
OraDirect not receive information about type from package...is this true??
hi... i'm using the following code
OracleCommand cmd = this.connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "store.seg_tis";
OracleParameter param = new OracleParameter("s_tis", OracleDbType.Table);
param.Direction = ParameterDirection.Output;
param.ObjectTypeName = "gral.p_tis";
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
this is the TYPE
CREATE OR REPLACE PACKAGE Gral AS
TYPE p_tis IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
...
this is the error
OCI-22303: type GRAL.P_TIS no found
i use OraDirect.NET 4.25 for .Net 2 and Oracle9i
i no use the direct mode..
thanks
OracleCommand cmd = this.connection.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "store.seg_tis";
OracleParameter param = new OracleParameter("s_tis", OracleDbType.Table);
param.Direction = ParameterDirection.Output;
param.ObjectTypeName = "gral.p_tis";
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
this is the TYPE
CREATE OR REPLACE PACKAGE Gral AS
TYPE p_tis IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
...
this is the error
OCI-22303: type GRAL.P_TIS no found
i use OraDirect.NET 4.25 for .Net 2 and Oracle9i
i no use the direct mode..
thanks
We don't know a bug number. But this problem was discussed in several threads at Oracle forum (e.g., http://forums.oracle.com/forums/thread. ... dID=513774 ).