Thanx for responding and solving so many plsql problem. Answer by you are always correct and useful.

Hi. What to do if the table type has more than one column? Is there a way to use column_name in this scenario?

create or replace type obj as object (
  x int, y int
);
/

create or replace type obj_arr as table of obj;
/

declare
  v obj_arr;
begin

  v := obj_arr ( obj ( 1, 2 ), obj ( 3, 4 ) );
  
  for rws in (
    select t.x, t.y from table ( v ) t
  ) loop
    dbms_output.put_line ( rws.x || ' ' || rws.y );
  end loop;

end;
/

1 2
3 4

create or replace TYPE INP_OBJ AS OBJECT

( NAME VARCHAR2(9 CHAR)

,ADDRESS1 VARCHAR2(50 CHAR)

,ADDRESS2 VARCHAR2(50 CHAR)

,CITY VARCHAR2(5 CHAR) );


create or replace TYPE INP-TAB AS TABLE OF INP_OBJ ;

I have 3 rows in the inp-tab and I want to move 2nd row of inp-tab to a blob field (say L-blob-field ).

I dont want to concatenate field by field and move it to l-blob-field. is there a way move the whole record (all column) in to a blob field ?

Note: In actual input-table i have 30 column and i need to move the it to blob field and insert it to a error table incase of failure.