Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Truncating tables in Forms 4.5

Re: Truncating tables in Forms 4.5

From: Nuno Guerreiro <nuno-v-guerreiro_at_invalid.telecom.pt>
Date: Tue, 09 Mar 1999 10:26:16 GMT
Message-ID: <36e4f71a.343813858@news.telecom.pt>


On 9 Mar 1999 09:59:04 GMT, "Wicksey" <Wicksey_at_hotmail.com> wrote:

>Hi people,
>
>Does anyone know of a command equivalent to TRUNCATE TABLE which can be
>executed in a PL/SQL trigger in Forms 4.5? I have to delete from a few
>temporary tables and it seems to be taking increasingly longer. I have no
>need to rollback.
>Any suggestions would be appreciated.
>
>Thanks in advance,
>
>Wicksey

Use:

FORMS_DDL('truncate table table_name'); IF FORM_SUCCESS THEN
...
ELSE
...
ENDIF; Good Luck,

Nuno Guerreiro



As I don't normally appreciate unsolicited commercial e-mail (widely known as SPAM), I encoded my e-mail address. If you want to reply by e-mail, please remove the text added to fool spam software

"The art of arts, the glory of expression and the sunshine that lights the light of letters  is simplicity"

                                                        Walt Whitman Received on Tue Mar 09 1999 - 04:26:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US