(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.