#25924 [NEW]: PROBLEM TU USE ora_exec WITH ORACLE OWNER VARIABLE TYPE

From: fabio dot curti at vtin dot it Operating system: Red Hat Linux release 7.3 PHP version: 4.3.2 PHP Bug Type: Oracle related Bug description: PROBLEM TU USE ora_exec WITH ORACLE OWNER VARIABLE TYPE Description: ------------ The call to the following stored procedure (oracle 8.1.7) from php4.2.1 (as ampache module) does not work with a OWNER ORACLE TYPE VARIABLE. HOW CAN I DO ??...DOES ORACLE EXTENSION FUNCTION SUPPORT DIFFERENT TYPES OF VARIABLE ?? Reproduce code: --------------- PHP CODE ora_parse($this->db_cursor,"begin Top_Queries_Pkg.EstraiTopQuery(:O_S_QString); end;"); ora_bind($this->db_cursor, "top_query", ":O_S_QString",80000000, ORA_BIND_OUT); ora_exec($this->db_cursor); where STORE PROCEDURE IS procedure EstraiTopQuery (O_S_QString Out string_array_huge) where string_array_huge is CREATE OR REPLACE TYPE "STRING_ARRAY_HUGE" AS VARRAY (4000) OF VARCHAR2(2000) Expected result: ---------------- I EXPECTED A STRING...VERY LONG BUT A STRING. Actual result: -------------- Warning: Ora_Exec failed (ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'ESTRAITOPQUERY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored -- while processing OCI function OEXEC/OEXN) in -- Edit bug report at http://bugs.php.net/?id=25924&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=25924&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=25924&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=25924&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=25924&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=25924&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=25924&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=25924&r=support Expected behavior: http://bugs.php.net/fix.php?id=25924&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=25924&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=25924&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=25924&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=25924&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=25924&r=dst IIS Stability: http://bugs.php.net/fix.php?id=25924&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=25924&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=25924&r=float