statments in a single query. Bassically if you need a semi-colon then it
won't work. The only real alternative (aside from acquiring a suitable
third party driver) is to encapsulate the functionality in functions and
stored procedures and then call those.
Tyler Clendenin
GSL Solutions
_____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 11:01 AM
To: CF-Talk
Subject: executing a PL/SQL Block
Is there some special requirement to executing a PL/SQL block of code in
CFMX? I had a block that ran in CF 5 fine. It looked like this:
<cfquery name="finalizecycle" datasource="#request.datasource#">
declare
jobno BINARY_INTEGER;
BEGIN
DBMS_JOB.SUBMIT(jobno,'commcycles.FinalizeCycle(''<cfoutput>#cc#</cfoutput>'
',to_date(''<cfoutput>#cd#</cfoutput>'',''MM/DD/YYYY HH12:MI:SS
PM''),<cfoutput>#request.logemplid#</cfoutput>);',sysdate);
Commit;
END;
<cfquery>
The error we get now is a PL/SQL error, which means it is at least executing
the query block, but somehow differently.
Error Executing Database Query. [Macromedia][Oracle JDBC
Driver][Oracle]ORA-06550: line 1, column 8: PLS-00103: Encountered the
symbol "" when expecting one of the following: begin function package pragma
procedure subtype type use cursor form current
The error occurred on line 55.
****************************************************************************
**************
The information contained in this message, including attachments, may
contain
privileged or confidential information that is intended to be delivered only
to the
person identified above. If you are not the intended recipient, or the
person
responsible for delivering this message to the intended recipient, ALLTEL
requests
that you immediately notify the sender and asks that you do not read the
message or its
attachments, and that you delete them without copying or sending them to
anyone else.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
