Page 1 of 1

How to get type form package?

Posted: Tue 18 Oct 2005 04:13
by Sergius
So, that is problem.
I'm want create CoreLab.Oracle.OracleArray:

OracleArray f=OracleArray("schema.type", Connection)

that work correctly, but if I write

OracleArray f=OracleArray("schema.package.type", Connection)

I get exception 'OCI-22303 type "schema"."package.type" not found'

How I can solve this problem?

Posted: Tue 18 Oct 2005 07:15
by Paul
We suppose that you use PL/SQL type in your package ("... IS TABLE OF ...").
Please see "Working with PL/SQL tables" article in OraDirect .NET documentation.