inner_cursor.outer_cursor.field

outer_cursor.field

inner_cursor.(outer_cursor.field);

CREATE TABLE BIG_TABLE
(
   ID VARCHAR2(50),
   Pk_A VARCHAR2(50),      
   PK_B VARCHAR2(50),
   PK_C VARCHAR2(50),
   PK_D VARCHAR2(50)
);

CREATE TABLE RELATION_TABLE
(
   ID VARCHAR2(50),
   SOURCE_TABLE VARCHAR2(50),
   SOURCE_PK VARCHAR2(50),
   SOURCE_FK VARCHAR2(50),
   DESTINATION_TABLE VARCHAR2(50),
   DESTINATION_PK VARCHAR2(50)
);

CREATE OR REPLACE PROCEDURE TEST1                                           
AS
	CURSOR loop_relation IS
		SELECT * FROM RELATION_table;
	relation_rec loop_relation%rowtype;
	CURSOR loop_pk_TABLE IS
		SELECT * FROM pk_TABLE;
	pk_TABLE_rec loop_pk_TABLE%rowtype;
BEGIN
	FOR RELATION_REC IN LOOP_RELATION
	LOOP
		FOR pk_TABLE_rec in loop_pk_TABLE
		LOOP
			IF (pk_TABLE_REC.RELATION_REC.DESTINATION_PK IS NULL) THEN    --MY PROBLEM,I CANT USE THREE DOTS
				UPDATE PK_TABLE
				SET PK_TABLE.RELATION_REC.DESTINATION_PK = 'NOT IMPORTANT'  --OOPS, ANOTHER THREE DOTS
				WHERE PK_TABLE_REC.ID = PK_TABLE.ID;
			END IF;
		END LOOP;
	END LOOP;	
END TEST1;
/

inner_cursor.outer_cursor.field

outer_cursor.field

inner_cursor.M

declare
junk number;
begin
for pnt in (select col1 from my_table order by col1) loop
  for pnt2 in (select col2 from their_table order by col1) loop
     junk := pnt.col1 + pnt2.col2;
  end loop;
end loop;
end;

PK_TABLE.RELATION_REC.DESTINATION_PK

CREATE OR REPLACE PROCEDURE TEST1                                           
AS
	CURSOR loop_relation IS
		SELECT * FROM RELATION_table;
	relation_rec loop_relation%rowtype;
        VAR1 VARCHAR2(4000);
        VAR2 VARCHAR2(4000);
BEGIN
	FOR RELATION_REC IN LOOP_RELATION
	LOOP
                VAR := ' CREATE OR REPLACE PROCEDURE TEST AS
                            CURSOR loop_pk_TABLE IS
                               SELECT * FROM pk_TABLE;
                         BEGIN
		            FOR pk_TABLE_rec in loop_pk_TABLE
		            LOOP
			       IF (pk_TABLE_REC.'||RELATION_REC.DESTINATION_PK||' IS NULL) THEN    --MY PROBLEM WAS I COULDN'T USE TOW DOTS
				  UPDATE PK_TABLE
				  SET PK_TABLE.'||RELATION_REC.DESTINATION_PK'|| = (IT CAN BE ANY THING,IN MY MAIN CODE IS A QUERY SELECT)  --ANOTHER TOW DOTS
				  WHERE PK_TABLE_REC.ID = PK_TABLE.ID;
			       END IF;
		            END LOOP;
                         END TEST;'
                    EXECUTE IMMEDIATE VAR;
                    var2 := 'begin test(); end ;';
                    EXECUTE IMMEDIATE VAR2;
	END LOOP;	
END TEST1;
/