Pat,
thanks for your reply. If you look at my original posting I have tried that route as suggested by OraFusion ( http://www.orafusion.com). I have also tried using the CFSAVECONTENT, then replacing chr(10)chr(13) with a space; I have also tried by putting BR tags at the end of each line and then replacing the BR tags with a space - same results every time.
Steve
-----Original Message-----
From: Whittingham, P [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 4:17 PM
To: CF-Talk
Subject: RE: Help executing PL/SQL
just use a variable to build your pl/sql... and concat it.
Pat
-----Original Message-----
From: Semrau Steven Ctr SAF/IE [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 3:50 PM
To: CF-Talk
Subject: RE: Help executing PL/SQL
Yes, doing this:
<cfquery name="davidTest" datasource="#mysession.dcname#">
BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END;
</cfquery>
returns:
davidTest (Records=0, Time=94ms)
SQL =
BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END;
And doing this:
<cfquery name="davidTest" datasource="#mysession.dcname#">
BEGIN
UPDATE SYSTEMINFO
SET LOGINPAGEMESSAGE = 'Welcome to here'
WHERE DATACALL = 2;
END;
</cfquery>
returns:
Oracle Error Code = 6550
ORA-06550: line 1, column 7: PLS-00103: Encountered the symbol "" when expecting one of the following: begin case declare exit for goto 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;"
How irritating is that!? Hehehe - man I'm at wits end trying to figure this out.
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 3:41 PM
To: CF-Talk
Subject: Re: Help executing PL/SQL
It does work if it's all on one line, not set as a variable first? (I can't
test it, as we don't have ODBC datasources set up.)
----- Original Message -----
From: "Semrau Steven Ctr SAF/IE"
> 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
>
_____
_____
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Help executing PL/SQL Semrau Steven Ctr SAF/IE
- Re: Help executing PL/SQL Deanna Schneider
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- Re: Help executing PL/SQL Deanna Schneider
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- Re: Help executing PL/SQL Deanna Schneider
- RE: Help executing PL/SQL Whittingham, P
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- Re: Help executing PL/SQL Deanna Schneider
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- RE: Help executing PL/SQL Semrau Steven Ctr SAF/IE
- RE: Help executing PL/SQL Whittingham, P