Problem Report: Test Window and end-of-file on communications channel

[ScottMattes]

PLSD 10
Oracle 11
Win 7

I gave up working last night when I kept getting ORA-03113: end-of-file on communication channel while trying to run a test window that i had just created (copied it from the one I had just gotten done using successfully).

This morning, after PC shutdown last night, but still the same problem.

My first thought had been some network error. This morning I went back to the test I had copied this from and that one worked.

Finally narrowed it down to a repeatable bare minimum.

This does give the 3113 error.

begin
  select 1 into :asdf from dual;

  -- test statements here
  open :c_asdf for
  select *
    from dual;
end;

This gives the PLS-00456 item 'c_asdf' is not a cursor error.

begin
  -- test statements here
  open :c_asdf for
  select *
    from dual;
end;

In both case c_asdf is not a cursor.

 

[IvanZ]

This is an Oracle issue.

On 12.1.0.2
Both cases produce "PLS-00707: unsupported construct or internal error [2602]" wich is OK.

On 11.2.0.x
First case produce kernel fault (from alert log):
ORA-07445: exception encountered: core dump [ptkin()+256] [SIGSEGV] [ADDR:0x0] [PC:0x947D324] [SI_KERNEL(general_protection)] []

wich results in "ORA-03113: end-of-file on communication channel"

and the second case produce "PLS-00456: item 'C_ASDF' is not a cursor"