Forms 5 (PL/SQL) Need to TRUNCATE a table.

[andypara]

Hi,

I need to truncate an Oracle 8i table from within a Forms 5 trigger. I've tried :-

EXECUTE IMMEDIATE 'TRUNCATE TABLE CTR_EMPL';

But it thows back an error when I compile it saying it doesn't like "IMMEDIATE".

Can you use Dynamic SQL in Forms??

What syntax can I use to do this?

Many Thanks.

 

[sem]

Use forms_ddl built-in. Don't forget that this will issue commit.