• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2887
  • Last Modified:

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:

 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
1 Solution
declare your pl/sql table in a package within the database and use it there instead of in your forms pl/sql.
Mark GeerlingsDatabase AdministratorCommented:
Forms4.5 does not support your PL\SQL syntax.  Forms4.5 is based on the Oracle database version 7, which is now about 15 years old.  Many additions and enhancements have been made to PL\SQL in more recent years that are not supported by Forms4.5.

Your options are either:
1. Use a server-side stored procedure as sdstuber suggested.
2. Use an alternate technique that is supported by Forms4.5.
3. Upgrade to a newer version of Oracle Forms (Forms6 still supports client/server deployment if that is something you want/need)
geoffbatesAuthor Commented:
Many thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now