Query runs in SQL window, but crashes OraClient when run from package

[Roeland]

Following type is necessary for the example:

CREATE OR REPLACE TYPE "T_ARRAY_INTEGER" IS TABLE OF INTEGER

The following query executes nicely in a SQL-window.

select p.Dummy,
    Cast(MULTISET(SELECT LEVEL just_a_column
                  FROM   dual
                  CONNECT BY LEVEL <= 10) as t_array_integer) Type_Collection
      from Dual p

Put this in a package:

create or replace package ...

  procedure View_Collection (p_Cursor out sys_refcursor) is
  begin
    open p_Cursor for
      select p.Dummy,
        Cast(MULTISET(SELECT LEVEL just_a_column
                      FROM   dual
                      CONNECT BY LEVEL <= 10) as t_array_integer) Type_Collection
        from Dual p;
  end View_Collection;

Now test this procedure.
ATTENTION: YOU HAVE TO CLOSE PL/SQL DEVELOPER afterwards! Save any work!
Execute and fetch records from it, it gives me an
"Access violation at address 61EBD2D3 in module 'OraClient11.Dll'. Read of address 00000000"

I have tried this with some other Clients, but the AV stays.
I can execute and fetch in PL/SQL code though.

The behavior is strange because I have some procedures where it works correctly but when I remove some columns from the result set it starts crashing.

Roeland

PL/SQL Developer Version 8.0.4.1514
Oracle 10.2.0.4

 

[Marco Kalter]

This works fine for me. I'm using an Oracle 11.2 client and tested on an 11.2 and 10.2 server. Can you try this on an 11.2 client?

 

[Roeland]

Thanks for the info. Updated my client to 11.2 (from 11.1)

This fixed the issue.

Roeland