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

Linking QtCreator && OpenCv

c++ qt opencv mingw dynamic-linking

I'm having a problem linking a library from opencv(2.3.1) and can't find a way to resolve it..

Trouble Adding Custom Tools to SSIS Toolbox in Visual Studio 2010

visual-studio-2010 ssis bids

I'm using the SSIS Designer in Visual Studio 2010 and I recently downloaded a third-party suite of tools. Their post-install steps say to navigate to Tools > Choose Toolbox Items > SSIS Control Flow

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.