How to view the contents of tables created by the following procedure after the Loop?CREATE OR REPLACE PROCEDURE A0_BULK_COLLECT_TEST IS TYPE EMPLOYEE_MRNO IS TABLE OF A_REGISTRATION_HEADER.ARH_MR_NUM%TYPE; TYPE EMPLOYEE_NAME IS TABLE OF VARCHAR2(255); MRNUMBERS EMPLOYEE_MRNO; NAMES EMPLOYEE_NAME; CURSOR crBulkCollect IS SELECT ARH_MR_NUM, ARH_FIRST_NAME||' '||ARH_MIDDLE_NAME||' '||ARH_LAST_NAME FROM A_REGISTRATION_HEADER WHERE ARH_CTGRY_CD='EMP';BEGIN OPEN crBulkCollect; FETCH crBulkCollect BULK COLLECT INTO MRNUMBERS, NAMES; CLOSE crBulkCollect;END;

JV

• Jun 27th, 2006

 

FOR ALL j IN 1..MRNUMBERS.COUNT

dbms_output.put_line(MRNUMBERS(j));
dbms_output.put_line(NAMES(j));

D. Madhu

• Jun 29th, 2006

 

select * from user_objects where type='procedure' and name='function or procedure name'

kamala kanta Parhi

• Oct 14th, 2006

 

select text from user_source

where name='procedure_name';