I have this procedure and type in my oracle DB, the idea is use a collection like parameter, this is an example
CREATE OR REPLACE TYPE ARRAY_DATOS2 IS VARRAY(100) OF varchar2(500);
CREATE OR REPLACE PROCEDURE PRUEBA_VARRAY2(P_TIP IN VARCHAR2,P_CUR IN OUT ARRAY_DATOS2) IS
v_num number;
BEGIN
-- this line insert size of collection in table ARAUCANO
v_num:=P_CUR.count;
INSERT INTO ARAUCANO(CONTENIDO) VALUES (TO_CHAR(v_num));
-- this lines insert the content of each record in table ARAUCANO
for i in 1..P_CUR.count loop
INSERT INTO ARAUCANO(CONTENIDO) VALUES (P_CUR(i));
end loop;
COMMIT;
END;
Hello man, thanks to you for your work,
Problem and code
I have this procedure and type in my oracle DB, the idea is use a collection like parameter, this is an example
in my php i have this:
the $result is "true" but in table ARAUCANO is 0, the count of the collection, is 0
select * from araucano; 1 0
System details
ORACLE 12 DB PHP 5.5.1
ok, now check the function in your code
I found this in the type SQLT_NTY
in line 467, overwrite the value of the IN param with a new collection, I test that put this line before and after
the size is 3 and then 0
I replace the code with this
and solve the problem, result
this is a patch only for collections, I wait to you for a true solution
sorry by my english
thanks in advance