initialize a nested table [message #648311] |
Sat, 20 February 2016 03:30 |
|
live4learn
Messages: 41 Registered: September 2013 Location: Bangalore, India
|
Member |
|
|
SQL> desc t1;
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
C1 NUMBER Y
C2 VARCHAR2(90) Y
----------------
declare
-- Local variables here
type t1_typ is table of t1%rowtype;
tab1 t1_typ:=t1_typ();
begin
-- Test statements here
tab1.extend(1);
tab1(1):=t1_typ(1,'asdf');
end;
it is giving error
Ora -06550 - line 10,col 12
PLS 00306 wrong number or type of arguments in call to 'T1_TYP'
How can it be initialized ?
|
|
|
|
|
|