Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

using tables of records in pl sql

using tables of records in pl sql  using -'oracle,plsql,table'

I've declared the following types in my PL/SQL package:

TYPE t_simple_object IS RECORD (
   wert   NUMBER,
   gs     NUMBER,
   vl     NUMBER);

TYPE t_obj_table IS TABLE OF t_simple_object

Then I declare a variable:

obj t_obj_table;

However, when I want to use the variable, I cannot initialize or extend it:

obj := t_obj_table ();

gives the following errror:

PLS-00222: no function with name 'T_OBJ_TABLE' exists in this scope

If I don't initialize it, I can't extend it to add some date as


gives another error:

PLS-00306: wrong number or types of arguments in call to 'EXTEND'

How can I make this work?

asked Sep 29, 2015 by sameer rathore
0 votes

Related Hot Questions

Government Jobs Opening