ORA-03117 when using nested pl/sql-tables

Hi,

Firstly my compliments on a great tool.
The following package generates an ORA-03117 when you either create a test-window calling p1 or when you open the Parameter-node of procedure p1 in the object-browser.
It is caused by the nested pl/sql table type.

Code:
create or replace package tst
as
  type t1 is table of varchar2(1) index by pls_integer;
  type r2 is record ( t1_tab t1
                    , field1 varchar2(1)
                    );
  type t2 is table of r2 index by pls_integer;

  procedure p1
  ( p_t2 in out t2
  );
end tst;
/
create or replace package body tst
as
  procedure p1
  ( p_t2 in out t2
  ) is
  begin
    null;
  end p1;
end tst;
/
Regards,

Frank
 
Works fine for me. Apparently there is a problem describing this procedure on your configuration. Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?
 
Does any one know if this is definitly fixed in 10g. I'm running into this issue in 7.1 of PL/SQL developer with a 10g client.

See profile info. below:

PL/SQL Developer
Version 7.1.0.1337

Windows 2000 Professional 5.0 Build 2195 (Service Pack 4)

Physical memory : 515,568 kB (27,720 available)
Paging file : 1,244,868 kB (378,336 available)
Virtual memory : 2,097,024 kB (1,973,016 available)

Parameters
G:\Program Files\plsql developer7.0\plsqldev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
G:\Program Files\plsql developer7.0\Preferences\Default\Default.ini
G:\Program Files\plsql developer7.0\Preferences\dfglover\default.ini

Plug-Ins
*PL/SQL Documentation (plsqldoc) (G:\Program Files\plsql developer7.0\PlugIns\plsqldoc.dll)
(* is Active)

...

Homes
OraClient10g_home1 (D:\oracle\product\10.2.0\client_1)
OraHome90 (D:\oracle\ora90)

DLLs
D:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
D:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: D:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 0
NCharSetID: 0
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16
 
Back
Top