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

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

var := myFunction(...);

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


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


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?