Oracle ocinewcollection and collection defined inside package

[Tomislav Petrovic]

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.

[Andy Hassall]

On Fri, 16 Jan 2004 18:07:30 +0100, "Tomislav Petrovic" <t.********@inet.hr>
wrote:

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?

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

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