Truncate thru Forms

[WallWalker]

Plzzz tell me how can I truncate tables thru Forms 6i. Plzzz explain in easy steps as I m new to this....

thanks

[stecal]

Buy a book on Oracle Forms and read it. Prentice Hall has a good starter-level book titled, appropriately enough, Oracle Forms.

[WallWalker]

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

[thomasp]

CREATE OR REPLACE PROCEDURE trunc_table(tbl_name in varchar2)  	  		  						
IS
   PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
	execute immediate 'truncate table ' ||  tbl_name;
	 
END trunc_table;
/

[thomasp]

I'm just trying out how the php formatting looks.

CREATE OR REPLACE PROCEDURE trunc_table(tbl_name in varchar2)                                          
IS
   PRAGMA AUTONOMOUS_TRANSACTION;

BEGIN
    execute immediate 'truncate table ' ||  tbl_name;
     
END trunc_table;
/ 

[WallWalker]

Millions of THANKS thomasp

[bhattnirav]

use folowing command


forms_ddl('truncate table ;');