These are scripts for our development so that drop/recreate tables - pre-populate information - and so on can be done by us without having to go through these 'higher-up' DBAs every time we need to mess with the data.
I just wish I could get this figured out so I could tell the dba to just format your scripts like 'this and that' and drop them between the cfquery tags.
Steve
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Friday, May 28, 2004 12:29 PM
To: CF-Talk
Subject: Re: Help executing PL/SQL
Hm. Then I don't know what to tell ya.
----- Original Message -----
From: "Semrau Steven Ctr SAF/IE"
> Same results.
>
> <cfsavecontent variable="plsql">
> BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE
DATACALL = 2; END;
> </cfsavecontent>
> <cfquery name="davidTest" datasource="#mysession.dcname#">
> #plsql#
> </cfquery>
>
> results in:
> ORA-06550: line 1, column 50: PL/SQL: ORA-00933: SQL command not properly
ended ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]