DYNAMIC SQL SELECTION QUESTION

I posted a question earlier but that did not help me.

I need to insert data from joined files A - B into C

The tables are joined by the fields: SUN_DB & ACCOUNT_NR

BUT!!!! The name of file B's is partial "variable" and comes out of file A field: SUN_DB

Example:
Row of File A: field SUN_DB = "ZZZ" so File A has to be joined with Table: "B_ZZZ" by the fields SUN_DB & ACCOUNT_NR

Row of File A: field SUN_DB= "YYY" so File A has to be joined with Table: "B_YYY" by the fields SUN_DB & ACCOUNT_NR

There are +- 700 SUN_DB codes and so 700 TABLES TO JOIN WITH IN SHORT I need to run +-700 joines between Table A and variable Table Name B named: SALFLDG'||SUN_DB||'

Do I make myself clear?

I use the following script but some say it is far too complex for I try to achieve. For me this script is working fine but it is ignoring the following conditions "AND ACCNT_TYPE <> 'P' AND ANAL_A0 LIKE
'ABNA%'; "

Can anyone explain me why?

DECLARE retval INTEGER; CURSOR obj_cur IS

SELECT DISTINCT 'INSERT INTO C_SPIN (SUN_DB, ACCNT_CODE, TRANS_DATE, AMOUNT, ANAL_A0, ANAL_T0) SELECT SSRFACC.SUN_DB,SRFACC.ACCNT_CODE,TRANS_DATE, AMOUNT,SSRFACC.ANAL_A0, ANAL_T0 FROM SSRFACC,SALFLDG'||SUN_DB||' WHERE SSRFACC.ACCNT_CODE = SALFLDG'||SUN_DB||'.ACCNT_CODE AND SSRFACC.SUN_DB ='''||SUN_DB||''' ' CMDSQL FROM SSRFACC WHERE SUN_DB LIKE 'B%' AND ACCNT_TYPE <> 'P' AND ANAL_A0 LIKE
'ABNA%';
   drop_cursor INTEGER;
out_str VARCHAR2(1000);
BEGIN FOR obj_rec IN obj_cur LOOP drop_cursor := DBMS_SQL.OPEN_CURSOR;
out_str := obj_rec.cmdsql;
DBMS_SQL.PARSE (drop_cursor, out_str,
DBMS_SQL.NATIVE);
retval := dbms_sql.EXECUTE(drop_cursor); DBMS_SQL.CLOSE_CURSOR (drop_cursor);
END LOOP;
END; Received on Tue Jul 01 2003 - 16:06:24 CDT