<div>
declare your pl/sql table in a package within the database and use it there instead of in your forms pl/sql.
</div>


<div>
<div class="content wysiwyg-content">
I have the following code, I am attempting to create an array variablr to hold various data:<br />
<br />
DECLARE<br />
&nbsp;type t is table of number INDEX BY BINARY_INTEGER;<br />
<br />
I get the compiler error unexpected symbol &quot;of&quot;<br />
Forms does not like the type declaration for some reason
</div>
</div>


I have the following code, I am attempting to create an array variablr to hold various data:

DECLARE
 type t is table of number INDEX BY BINARY_INTEGER;

I get the compiler error unexpected symbol "of"
Forms does not like the type declaration for some reason

declare your pl/sql table in a package within the database and use it there instead of in your forms pl/sql.

I Oracle Forms 4.5 TYPE  IS TABLE OF varchar2(500)

I have the following code, I am attempting to create an array variablr to hold various data:

DECLARE
 type t is table of number INDEX BY BINARY_INTEGER;

I get the compiler error unexpected symbol &amp;quot;of&amp;quot;
Forms does not like the type declaration for some reason

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.