Re: PL/SQL Tables in Stored Procs

In article <1992Nov18.014202.7076_at_exu.ericsson.se> ebuhob_at_ebu.ericsson.se (Hans Bergsten 6264) writes:

> I am trying to use all the new great PL/SQL features in ORACLE7
> (Developer's Release, V7.0.10.3.1) in an applicationon the SunOS
> 4.1 platform....
>
> - In a package, I have to public variables declared like:
>
> TYPE IntTabType IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
> int_tab IntTabType;
> int_index BINARY_INTEGER;
>
> If I try to initiate these variables from SQL*Plus, I get the following
> results:
>
> SQL> begin test.intab(1) := 0; end;
> 2 /
> begin test.intab(1) := 0; end;
> *
> ERROR at line 1:
> ORA-06501: PL/SQL: internal error 75946, arguments: [], [], [], []
>
> SQL> begin test.i := 0; end;
> 2 /
>
> PL/SQL procedure successfully completed.

I tested these scenarios in 7.0.11.2 on VMS and they all create/execute successfully. Thanks for taking the time to test the new features. Hopefully you're finding them very flexible and useful overall, even if some glitches come up in the Developers' Release. We of course depend on curious souls such as yourself to poke at our software from all different angles and give us feedback like this.

Thanks.

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _   Steve Muench Email: smuench_at_oracle.com   SQL*Forms Development
  Product Manager
  Oracle Corporation Received on Fri Nov 20 1992 - 07:18:16 CET