2008-05-21

writing code that BULKs into a rowtype will crash the session

Another bug that i found....Someone already told me that they new of this issue also reported by me some two years ago but I could not remember it :-(
(it's the old age...)

Of course its a code error to make a bulk into a rowtype variable, but if you try to code it it will not give you an error it will crash the session!

Here goes the code sample that makes it happend :-(


CREATE TABLE a_test (a VARCHAR2(20));


create or replace package test_pck is
end test_pck;

Then try to create the package

create or replace package body test_pck is

PROCEDURE test1
IS
lrt_test a_test%ROWTYPE;
BEGIN
SELECT * BULK COLLECT INTO lrt_test FROM a_test;
END test1;
end test_pck;


This will crash the session ...I try with SQLNavigator and SQLPlus

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.