PL/SQL - How to view the contents of tables created by the following procedure after the Loop?CREATE OR REPLA

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 89 of 241

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;

Total Answers and Comments: 3

Last Update: October 14, 2006 Asked by: kameshakundy

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 27, 2006 14:08:15

RE: How to view the contents of tables created by the ...

FOR ALL j IN 1..MRNUMBERS.COUNT

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

Is this answer useful? Yes | No

June 29, 2006 16:44:23

D. Madhu

RE: How to view the contents of tables created by the ...

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

Is this answer useful? Yes | No

October 14, 2006 06:18:06

kamala kanta Parhi

RE: How to view the contents of tables created by the ...

select text from user_source

where name 'procedure_name';

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank