Connect programmer/p@9i


create or replace procedure Show_Rows_For_Dept_Dynamic_Sql (
  p_stmt in varchar2 ) is
  -- No prior- set-up or post- clean-up required
  -- to run this
  v_last_names_tab Employees_Cur_Dynamic_Sql.Last_Names_Tab_t;

begin
  v_last_names_tab := Employees_Cur_Dynamic_Sql.Fetch_All_Rows ( p_stmt );

  for j in v_last_names_tab.First..v_last_names_tab.Last
  loop
    Dbms_Output.Put_Line ( v_last_names_tab(j) );

  end loop;
end Show_Rows_For_Dept_Dynamic_Sql;
/
Show Errors