How to get type form package?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply

How to get type form package?

Post by Sergius » Tue 18 Oct 2005 04:13

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?

Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 18 Oct 2005 07:15

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.

Post Reply