title: PLSQL custom data type when calling procedures in php
body: <p>I am trying to call an PLSQL PROCEDURE with php, but i am having issues with custom data types.</p>
  
  <p>One of the columns in my table has the custom data type below.</p>
  
  <pre><code>create or replace TYPE CUST_ADDRESS_TYP 
      AS OBJECT 
      (   STREET_ADDRESS VARCHAR2 (40) , 
          CITY VARCHAR2 (30) , 
          STATE_PROVINCE VARCHAR2 (10) ,
          POSTAL_CODE VARCHAR2 (10) ,  
          COUNTRY_ID CHAR (2) 
      )  
  ;
  </code></pre>
  
  <p>Below is how i have the procedure</p>
  
  <pre><code>create or replace PROCEDURE process_order
  (
      p_customer_address in  CUSTOMER.CUST_ADDRESS%TYPE
  )
  IS
  </code></pre>
  
  <p>to insert into this colum in PLSQL this is a sample of what i use</p>
  
  <pre><code>CUST_ADDRESS_TYP('77 Old Street','San Diego','CA','94567','US')
  </code></pre>
  
  <p>and it works just fine</p>
  
  <p>However when i do this in PHP i get</p>
  
  <pre><code>$p_customer_address = "CUST_ADDRESS_TYP('45 High Street','Toronto','CO','94567','CN')";
  
  $stid = oci_parse($conn, 'begin process_order(:p_customer_address); end;');
  
  oci_bind_by_name($stid, ':p_customer_address', $p_customer_address);
  </code></pre>
  
  <p>Warning: oci_execute(): ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PROCESS_ORDER' ORA-06550</p>
  
  <p>Thank you.</p>