Devart Forums

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

This is a known Oracle bug.
Types from packages cannot be described.

So...wat is the solution for this??


thanks

Unfortunately, we don't know any.

Is this still the case with the latest version? I am running in to this exact same problem.

The problem persists. This is an Oracle bug.

By any chance do you know if Oracle is aware of this issue? If so, is there a bug number that you can supply. I like the capabilities I have seen so far and would like to "rattle their cage" so to speak to see if there is a possible work around.

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 ).