Oracle ocinewcollection and collection defined inside package

In Oracle I have:
CREATE OR REPLACE TYPE "NUMBER_TBL" AS TABLE OF NUMBER(11);
when I do in PHP:
$arr = ocinewcollection($db, 'NUMBER_TBL');
everything is fine and I get collection object...

on the other hand if I have in Oracle:
CREATE OR REPLACE PACKAGE "TRIAL" AS
TYPE VARCHAR2_TBL IS TABLE OF VARCHAR2(11);
END;
when I do in PHP:
$arr = ocinewcollection($db, 'VARCHAR2_TBL');
I get false with a warning:
Warning: ocinewcollection(): OCITypeByName: OCI-22303: type
"."."VARCHAR2_TBL" not found in d:\tomy\htdocs\info2.php on line 16

What should I do so the second example with collection inside package works?

Thank you, Tomy.

re: Oracle ocinewcollection and collection defined inside package

On Fri, 16 Jan 2004 18:07:30 +0100, "Tomislav Petrovic" <t.petrovic@inet.hr>
wrote:
[color=blue]
>In Oracle I have:
>CREATE OR REPLACE TYPE "NUMBER_TBL" AS TABLE OF NUMBER(11);
>when I do in PHP:
> $arr = ocinewcollection($db, 'NUMBER_TBL');
>everything is fine and I get collection object...
>
>on the other hand if I have in Oracle:
>CREATE OR REPLACE PACKAGE "TRIAL" AS
> TYPE VARCHAR2_TBL IS TABLE OF VARCHAR2(11);
>END;
>when I do in PHP:
> $arr = ocinewcollection($db, 'VARCHAR2_TBL');
>I get false with a warning:
>Warning: ocinewcollection(): OCITypeByName: OCI-22303: type
>"."."VARCHAR2_TBL" not found in d:\tomy\htdocs\info2.php on line 16
>
>What should I do so the second example with collection inside package works?[/color]

Presumably qualify the name, i.e. TRIAL.VARCHAR2_TBL.

--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>