[vibinvictoria]

Hi All,

I have written the pl/sql block.

DECLARE
type my_table
IS
  TABLE OF emp_info%rowtype;
  v_table my_table;
BEGIN
  SELECT * bulk collect INTO v_table FROM emp_info;
  FOR i IN v_table.first .. v_table.last
  LOOP
    dbms_output.put_line('' || v_table(i));
  --  dbms_output.put_line('hai');
  END LOOP;
END;

unable to execute above block, causing issue with 'dbms_output.put_line('' || v_table(i));' line.. Any help will really appreciate

thanks in advance,
vibinson Victoria.E

[Btu]

Since no one has answered I'll just show you what I did to make it work. I'm not sure what your intention is here, but this will work:

DECLARE
type my_table
IS
  TABLE OF customers%rowtype;
  v_table my_table;
BEGIN
  SELECT * bulk collect INTO v_table FROM customers;
  FOR i IN 1..v_table.count
  LOOP
    dbms_output.put_line('' || v_table(i).customer_id);
  END LOOP;
END;

dbms_output.put_line won't let you dump a whole row into the console. But you can output each field with a concatenation || ''