Okay, a somehow trivial problem, but I don't know how to do it right (from the oracle and php side)
A stored procedure/functio in Oracle should create N strings. And then return it to the caller.
I would like to pass something like a array back, or anything else that php can/will accept.
And I need the corresponding php code, to get the data into some vars.....
On the Oracle side, i've tried a lot of different things, but nothing seems to fully work.
The best so far:
TYPE sqlarray IS TABLE OF VARCHAR2(255);
function getSimpleArray
return sqlarray
IS
l_data sqlarray := sqlarray();
begin
for i in 1 .. 10 loop
l_data.extend;
l_data(l_data.count) := 'entry ' || i;
end loop;
l_data.extend;
l_data(l_data.count) := 'jo mann 1';
l_data(l_data.count) := 'jo mann 1456';
return l_data;
end getSimpleArray;
(from a package)
just what php code is able to handle l_data
