-
Truncate thru Forms
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
-
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
-
use folowing command
forms_ddl('truncate table ;');
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|