ocinewcollection recursive call
| From: | Ludányi Levente | Date: | Tue, 28 Oct 2003 08:29:03 +0000 |
| Subject: | ocinewcollection recursive call | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31325@lists.php.net to get a copy of this message | ||
Hello
I'm trying to use the OCINewCollection function, but if I don't specify the
'schema' parameter for this function, then I get the 'ocinewcollection(): OCI8
Recursive call!' error message, and the page never appears (I must restart IIS). If I give a
typename, that does not exsits on the Oracle server, then it ends up with the same results.
If I specify the 3. parameter, then I always get the 'type not found' message (OCI-22303),
and the php-variable gets bool(false) value.
Oracle:
CREATE TYPE "AR"."T1" AS
TABLE OF NUMBER(6, 0)
CREATE OR REPLACE PROCEDURE "AR"."GETTABLE" (
aaa out t1
)
is
begin
aaa:=t1(10);
end;
Php:
<?php
echo 'aaa';
$c=OCILogon("ar","ar");
$s=OCIParse($c,"begin gettable(:b); end;");
$bb=OCINewCollection($c,"t1");
echo var_dump($bb);
OCIBindByName($s,"b",&$bb,-1,OCI_B_SQLT_NTY);
OCIExecute($s);
OCIFreeStatement($s);
echo 'bbb';
?>
What's wrong?
Thanx.
LL