How to get type form package?

Sergius · 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?

Paul · 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.