Newsgroups: comp.databases.oracle From: mannhart@zuv.unizh.ch (Leo Mannhart) Subject: Re: How to create a table in PL/SQL? Message-ID: Followup-To: comp.databases.oracle Sender: newsadm@rzu-news.unizh.ch (CNEWS ADMINISTRATION) Organization: University of Zurich References: <2qoipv$dqk@gaia.cc.gatech.edu> Distribution: na Date: Wed, 11 May 1994 08:59:25 GMT Lines: 38 In article <2qoipv$dqk@gaia.cc.gatech.edu>, warner@cc.gatech.edu (Byron Warner ) wrote: > When I try to use create in a SQL*Forms procedure I get this > message: > > PL/SQL error 103 at line 9, column 7: > Encountered the symbol "CREATE" which is an unsupported reserved word. > > Does anyone know why? > > I was stuffing the string #in(1,2,3,.. ) into a field during a PRE-QUERY > trigger, but this blows up if the string is to long, so I decided to put > the keys into a temporary table and put the string #in(select * from > into the key field instead, but I can not create a temporary table. DDL-statements are not allowed in a pre-query trigger (there should be no problem in executing DDL-statments by redefining the app KEY (enter-query execute-query resp.) other than a possible "record changed by an other user". But why not defining the query-length for that field with CHAR(255) ? Is it already that long? > > > -- > Byron F. Warner | Phone: (404)953-4531 > College of Computing | Internet: warner@cc.gatech.edu > Georgia Institute of Technology | Atlanta Georgia, 30332 > "The opinions expressed here should be yours too!" -- Leo Mannhart Planning Office University of Zurich phone: ++41 1 257 23 34 Kuenstlergasse 15 fax: ++41 1 257 22 12 CH-8001 Zurich, Switzerland eMail: mannhart@zuv.unizh.ch