SQL & PL/SQL

Hello,

I have several commands in a store procedure. They are all generated dynamically , something like below .

l_sql := 'DELETE FROM ' || l_orig_table_name || ' WHERE site = :site AND day < :day';

EXECUTE IMMEDIATE l_sql USING l_site_name, l_days;

I do not know why nothing happens in any of the commands .

It just does nothing. Though when I add a bad command it do returns an error.


I have also 'INSERT INTO ..... SELECT....' that does not work.


could anybody give me a hint. I've been looking everywhere for an answer without success.
Thanks,

John,