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;

  • Interview Candidate
  • 3
  • 2465

Showing Answers 1 - 3 of 3 Answers

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'

  Was this answer useful?  Yes

kamala kanta Parhi

  • Oct 14th, 2006
 

select text from user_source

where name='procedure_name';

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions