Why cfstoredproc no worky on this?
If we must kludge
...try "execute immediate dbms_wm.gotoworkspace('x')"
...using cfexecute to run a shell script or bat file that runs sqlplus,
connects, execs the command and exits sqlplus.
...create a trigger on a table that is one column and one row and when
you update the row to edsWorkspace, the trigger executes the dbms_wm
procedure.
...I'll have to do some research on this, but I think you might can set
the default workspace based on the oracle user and so if your CF DSN
user is x then the workspace will be 1 and when the dsn user is y then
the workspace could be 2.
hth.
mf
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, September 06, 2007 4:10 PM
To: [email protected]
Subject: [ACFUG Discuss] Running a system command from ColdFusion
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
