Re: Help on PL/SQL tables

Hi, Rajashekar
Look my notes below

Rajashekar Aerrabotu wrote:
>
> Hi,
> I would appreciate if someone out there could help me figure out
> as to why am not able to create PL/SQL table.
>
> I am doing a Forms 4.5 application and require to store the extracts
> from cursor into a PL/SQL table for future manipulation of the stored
> contents. But the problem is coming in the declaration part of PL/SQL
> table. The language is unable to recognize the syntax of PL/SQL table
>
> ie TYPE access_group IS TABLE OF dap.dap_data_value1.access_group%type
> INDEX BY BINARY_INTEGER;
>
> can anyone see any mistake in the syntax but am getting a error as
>
> Error 103 at line 2,column 31
> Encountered the symbol "OF" when expecting one of the following
> "{"
>
> can anyone tell me why it is happening. I know that Forms 4.5 is
> supported by PL/SQL 2.0 so all that is present in PL/SQL 2.0 should be
> supported by Forms 4.5 isn't it?---»»»
  Be careful when you are using pl/sql in forms 4.5 .   We are tempted to use pl/sql 2.x statements in forms 4.5, but   the product only recognises pl/sql 1.x.   You can do that when forms 5.0 appears.

  The workaround is to put, when it is possible, the pl/sql code   in database using the procedural option.

  For your problem, why don't you use a record group in forms 4.5   to do that? It's easy, efficient and there are a lot of built-ins   to manage that.

---»»»
>
> I appreciate all the answers towards solving my problem.
>
> Thanks
> Rajashekar
 

-- 
I hope this help         +----------------------------------------+
                         | A.Jorge Florindo              PORTUGAL | 
  Regards                | E-Mail: ajf.63_at_mail.telepac.pt         |
   Jorge                 +----------------------------------------+