How to open custom type from plsql on php?

I have created a type on Oracle

CREATE OR REPLACE TYPE  myType as object (
id number,rol varchar(16) );‚Äč

Then I have this function that returns an object of type myType

create or replace FUNCTION myFunction(...) RETURN myType IS
.... 
END;

On plsql I can access the attributes of the returned object just doing this:

var := myFunction(...);
dbms_output.put_line(var.rol);

But how can I have access to the object attributes from php using OCI8

Answers


First create a type of that object to be able to return it as a table.

CREATE TYPE tableType AS TABLE OF myType

Then, using Oracle's table() function you can handle the output as a normal select on PHP

select *
from   table(myFunction(...))

simple, huh? :)

(edited as requested for completeness)


Need Your Help

Push Notification Certificates/ Profiles for Watch Kit

ios itunesconnect watchkit provisioning-profile

I'm about ready to submit my watchkit app to the app store. Finally.

Eclipse: Set maximum line length for auto formatting?

java eclipse formatting ide

I am working with Java. If I hit Ctrl+Shift+F in Eclipse Helios, it will auto format my code. At a certain point, it wraps lines. I would like to increase the maximum line length. How can I do this?