Search found 4 matches
- Thu 28 Aug 2008 16:35
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16097
- Wed 27 Aug 2008 18:07
- Forum: dotConnect for Oracle
- Topic: about create ado.net entity data model
- Replies: 25
- Views: 16097
- Tue 06 Nov 2007 16:48
- Forum: dotConnect for Oracle
- Topic: OraDirect not receive information about type from package...is this true??
- Replies: 7
- Views: 3044
- Tue 06 Nov 2007 14:05
- Forum: dotConnect for Oracle
- Topic: OraDirect not receive information about type from package...is this true??
- Replies: 7
- Views: 3044
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