create a table through pl/sql code block
Posted on 2007-12-02
i am using oracle forms, and i want to create a table and then drop it inside the pl/sql code in a 'when-button-pressed' trigger. but when i am writing the syntax, it gives a compilation error :
'encountered the symbol create when expecting the following
begin case declare exit for goto if loop mod null pragma.......'
Is there any way i can create and drop a table from inside the trigger code?