Re: Dynamic SQL selection question

Do you really want to do it this way? Horribly not scalable. Performance is going to suck. Use bind variables.

Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Ton" <76434.1353_at_compuserve.com> wrote in message
news:4477604.0306170404.50ae7b0d_at_posting.google.com...


> Can someone explain me why the following statement is ignoring the "

> ANAL_A0 LIKE 'ABNA%'" condition. It returns also records which do not

> comply with this selection criterion.

> Thanks

>

> DECLARE retval    INTEGER; CURSOR obj_cur IS SELECT DISTINCT

> 'INSERT INTO C_SPIN (SUN_DB, AMOUNT, TRANS_DATE) SELECT

> SSRFACC.SUN_DB, SUM(AMOUNT), TRANS_DATE 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;