php + oci8, table type column, ORA-00932
<p>My context: i'm developing and supporting some php application, working with Billing APP API trough Oracle functions/procedures and views.
From time to time i'm updating my code because of billing API changes.
But last update billing api update has broke all =\</p>

<p>API developers has added to allmost all views table-type column. Here is it's definition:</p>

<pre><code>  CREATE OR REPLACE FORCE VIEW "AIS_NET"."SI_V_SUBJECTS" ... AS 
  SELECT N_SUBJECT_ID,
.....
CAST(
         MULTISET(
           SELECT VC_CODE
           FROM   SI_V_ENTITIES_TAGS
           WHERE  N_ENTITY_ID = S.N_SUBJECT_ID
           AND    N_ENTITY_TYPE_ID = SYS_CONTEXT('CONST', 'ENTITY_TYPE_Subject')
           ORDER BY N_LINE_NO) AS TAGS)                T_TAGS,
.....
</code></pre>

<p>And when i'm trying to fetch</p>

<pre><code>select * from SI_V_SUBJECTS
</code></pre>

<p>i'm getting an error:</p>

<pre><code>oci_fetch_assoc(): ORA-00932: inconsistent datatypes: expected CHAR got TABLE
</code></pre>

<p>If i define columns without T_TAGS, something like "select N_SUBJECT_ID, VC_CODE FROM SI_V_SUBJECTS", all is good.</p>

<p>But i dont want to go through all of my code and define fields to selecting.</p>

<p>Maybe there is some hints/tricks to fetch table type columns with php/oci8?</p>

<p>Thank you and sorry for my bad english!</p>