Re: Trying to create a sequence from Forms Trigger?
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 25 Jun 1998 15:51:57 GMT
Message-ID: <6mtrmu$b1n1_at_hendrix.csufresno.edu>
http://members.aol.com/stevec5088
QA utility form: display/update any table Received on Thu Jun 25 1998 - 17:51:57 CEST
Date: 25 Jun 1998 15:51:57 GMT
Message-ID: <6mtrmu$b1n1_at_hendrix.csufresno.edu>
In article <6mr6v4$351$1_at_winter.news.erols.com>, <agibbons_at_erols.com> wrote:
>Any suggestions on how to create a sequence
>from within a Forms PL/SQL WHEN-BUTTON-PRESSED
>trigger.
>
>The compiler gives an error message when the
>SQL code for creating the sequence is encountered.
>
>Have tried EXEC SQL create sequence my_sequence...
>but without success.
Try: Forms_DDL('create sequence my_sequence...');
Steve Cosner
http://members.aol.com/stevec5088
QA utility form: display/update any table Received on Thu Jun 25 1998 - 17:51:57 CEST