Plzzz tell me how can I truncate tables thru Forms 6i. Plzzz explain in easy steps as I m new to this....
thanks
Printable View
Plzzz tell me how can I truncate tables thru Forms 6i. Plzzz explain in easy steps as I m new to this....
thanks
Buy a book on Oracle Forms and read it. Prentice Hall has a good starter-level book titled, appropriately enough, Oracle Forms.
Dear Stecal, alot of ppl have suggested that its not possible from Forms 6i but possible from Stored Procedures and those procedures can be called from Forms.
I've tried but thats also not working. Is there any1 who can tell me syntex for truncating tables in Stored Procedures.
Thanks in advance :confused:
Code:CREATE OR REPLACE PROCEDURE trunc_table(tbl_name in varchar2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
execute immediate 'truncate table ' || tbl_name;
END trunc_table;
/
I'm just trying out how the php formatting looks.
PHP Code:
CREATE OR REPLACE PROCEDURE trunc_table(tbl_name in varchar2)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
execute immediate 'truncate table ' || tbl_name;
END trunc_table;
/
Millions of THANKS thomasp :D
use folowing command
forms_ddl('truncate table;');