I would like to run an Oracle system command from ColdFusion. My
research revealed a way to execute PL/SQL with a <cfset> tag as shown
below.
<cfset variables.plsql = " declare x number; begin := 0; end; " >
<cfquery name="q" datasource="yourDSN"> #variables.plsql# </cfquery>
But I need to run an exec command.
I tried this:
<cfset variables.plsql = "exec DBMS_WM.GoToWorkspace('edsWorkspace')" >
<cfquery name="gotoWorkspace" datasource="emstraining.1">
#variables.plsql#
</cfquery>
and I get an invalid SQL statement error. Anyone know if this can be
done, and how?
Thanks!
----------------------------------------------------------------------
Ed Szwedo
Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955 (Voice)
919-685-3395 (Fax)
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
