PL/SQL Tables in Stored Procs
From: Hans Bergsten 6264 <ebuhob_at_ebu.ericsson.se>
Date: 18 Nov 92 01:42:02 GMT
Message-ID: <1992Nov18.014202.7076_at_exu.ericsson.se>
Date: 18 Nov 92 01:42:02 GMT
Message-ID: <1992Nov18.014202.7076_at_exu.ericsson.se>
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.e. it works fine to initiate the BINARY_INTEGER but not the PL/SQL Table.
In general, I get a feeling that the PL/SQL package is very flaky. Considering that this is V7.0.10 (and the rumor has it that V7.0.12 will be the last "prerelease version") I wonder how stable it will be in the real release.
Does anyone else have similar experiences? Have you heard if ORACLE are aware of problems in the PL/SQL area? I have not seen anything in the README files about it.
Regards,
Hans
Hans Bergsten Internet : ebuhob_at_ebu.ericsson.se Ericsson Business Communications MEMO : ERI.EBU.EBUHOB (God forbid.) 525 N. Muller St. Voice : +1 (714) 491-6264 Anaheim, CA 92803, USA FAX : +1 (714) 535-1789Received on Wed Nov 18 1992 - 02:42:02 CET