title: How to fix invalid name pattern: SCHEMA_NAME:VARCHAR_ARRAY
body: <p>I have dropped and created a TYPE using </p>
  
  <pre><code>drop type VARCHAR_ARRAY force;
  
  create or replace
  TYPE varchar_array AS TABLE OF VARCHAR2(4000);
  </code></pre>
  
  <p>and i am having a stored <code>proc</code> which takes <code>varchar_array</code> as <code>IN</code> parameter and am getting <code>DBException:invalid name pattern: SCHEMA_NAME:VARCHAR_ARRAY</code>.
  Can anyone let me know where am going wrong?</p>
  
  <p>Thanks in advance</p>