<!--- 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]
