Oracle Error Code = 6550
ORA-06550: line 1, column 6: PLS-00103: Encountered the symbol "" when expecting one of the following: begin case declare exit for go to if loop mod null pragma raise return select update while with << close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe
SQL = "BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = ''Welcome to here'' WHERE DATACALL = 2; END;"
I tried replacing the 3rd attribute with just a (space) instead of the (comma) - same error results
I tried removing the var setting for replaceList() - same error results
Argh, this is aggravating - I know it shouldn't be this hard to accomplish :( any other suggestions?
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 2:56 PM
To: CF-Talk
Subject: Re: Help executing PL/SQL
Did you try my suggestion? Here, let me be more verbose:
<!--- Write your nicely formatted pl/sql code --->
<cfsavecontent variable="plsql">
BEGIN
UPDATE SYSTEMINFO
SET LOGINPAGEMESSAGE = 'Welcome to here'
WHERE DATACALL = 2;
END;
</cfsavecontent>
<!--- strip out the line breaks --->
<cfset plsql = replacelist(plsql, "#chr(10)#,#chr(13)#", " , ")>
<!--- run it --->
<cfquery...>
#plsql#
</cfquery>
----- Original Message -----
From: "Semrau Steven Ctr SAF/IE"
> Here is my situation:
>
> my DBA is having problems getting the his scripts run on the Oracle server
(he does not have direct access and we have to pass off anything to a higher
dba to run WHENEVER he may have a chance) and would like me to create some
pages where he can drop his PL/SQL scripts between CFQUERY tags to run.
>
> I know I've seen posting in the past where people have done this and I
have even reviewed the OraFusion (http://www.orafusion.com) site with their
examples and work-around for CF5:
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
