Checking if a record type variable is null is failing with code 00306
779550Jul 11 2011 — edited Jul 11 2011Hi,
I have a Type Record Type
Type rt_my_type is Record (
field1 varchar(20),
field2 varchar(25));
I have a table type
Type tt_my_table IS TABLE OF rt_my_type ;
In my procedure I have two variables of each type
var_coll tt_my_type;
var_rt rt_my_type;
I have a code segment
IF var_rt IS NULL
var_rt := var_coll(0);
END IF;
While compiling I get the error. wrong number or type of arguments in call to 'IS NULL'.
If I comment out my if check it compiles fine. Can somebody help please?
Thanks
Paddy