Access cursor in cursor ...

[ggnanaraj]

Hi

The requirement is as follows:

Have a table (l_valid) that has 5 columns, of which 4 columns hold the name of related tables and 1 column has a key.

Now, I need to access these 4 tables using the key in a cursor. (this I have done).

Furthermore, after getting the names of 4 tables using the key, I need to iterate through the columns of each of these 4 tables in a cursor. How do I do this?

I done the following till now...

CURSOR c1 IS
		SELECT  hrank a, dbv b, dgv c, bbv d, fbv e, abv f, rbv g
		from l_valid
		where dbv is not null or
		fbv is not null or
		dgv is not null or
		bbv is not null or
		abv is not null or
		rbv is not null;

	CURSOR c2(p_b tab.tname%type) IS
		SELECT tname h 
		FROM tab
		WHERE tname = p_b;

Thanks for your input.