My DB guy wants (reasons I can't explain) me to run some SQL with the CFQUERY tag. When I run the code below as is (multiple lines):
<cfquery name="myName" datasource="#mydatasource#">
BEGIN
UPDATE SYSTEMINFO
SET LOGINPAGEMESSAGE = 'Welcome to here'
WHERE DATACALL = 2;
END;
</cfquery>
I'm getting an error of:
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
However, if I run the SQL as ONE line:
<cfquery name="myName" datasource="#mydatasource#">
BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END;
</cfquery>
This runs fine.
Our situation is that I have SQL that is a couple hundred lines long and putting that all on one line just doesn't make sense. I've seen messages in the past with SQL code done line by line within a CFQUERY - where am I going wrong here!?!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
