ociNewCollection and package
| From: | Olaf Taesch | Date: | Wed, 26 Sep 2001 05:01:22 +0000 |
| Subject: | ociNewCollection and package | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12726@lists.php.net to get a copy of this message | ||
Hi,
following the example in conf.php.net/oci with declaring the typ
outside a package is runs!
trying in php
$arr = OCINewCollection($conn,"TEST.ARR_CHAR");
only brings:
Warning: OCITypeByName: OCI-22303: type ""."TEST_OLE.ARR_CHAR" not found
but the type ARR_CHRR declared in the package
<cut>
CREATE OR REPLACE PACKAGE TEST IS
TYPE ARR_CHAR IS VARRAY(100) OF VARCHAR2(100);
PROCEDURE xxx(p_xxx in ARR_CHAR);
END TEST;
/
CREATE OR REPLACE PACKAGE BODY TEST AS
PROCEDURE xxx(p_xxx in ARR_CHAR) IS
BEGIN
...
</cut>
any ideas?
thanks!
Olaf