Re: dynamic sql question

I prefer "execute immediate". Check this. Hope it'll help you continue.

l_string := 'begin '||'stat_insert_'||l_source||'.insert_handler(:1, :2); end;';

execute immediate l_string using out l_number_inserted, out l_record_message;

You're using OUT arguments. Test them with something like.

dbms_output.put_line(l_number_inserted || '-' || l_record_message); Received on Tue Jan 31 2006 - 08:36:02 CST