« Custom Interaction
Read XML schema with DataSet and output its structure »

This type is local to this block



 

SQL>

SQL>

SQL> CREATE OR REPLACE TYPE NameList AS

  2    VARRAY(20) OF VARCHAR2(30);

  3  /



Type created.



SQL>

SQL>

SQL> DECLARE

  2

  3    TYPE DateList IS VARRAY(10) OF DATE;

  4

  5    v_Dates DateList;

  6    v_Names NameList;

  7  BEGIN

  8    NULL;

  9  END;

 10  /



PL/SQL procedure successfully completed.



SQL>

SQL>



 

Tags: , , , , ,

Posted in Uncategorized |

This entry was posted on Saturday, July 25th, 2009 at 10:24 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply