Are you sure this ran okay when you cut and paste it into SQL*Plus?
At 09:10 AM 10/7/2004 +0100, you wrote:
>I'm not an Oracle expert, but it is possible on most
>drivers/datasources to prohibit certain commands - i.e. when you run
>it thru SQL PLUS you have permission to run a CREATE command, but
>through you CF datasource it may be prohibitted.
>
>Just a thought.
>
>On Wed, 06 Oct 2004 14:53:30 -0400, Adrienne Brown
><[EMAIL PROTECTED]> wrote:
> > Is it possible to execute code that creates a temporary table using a
> > cfquery tag?
> >
> > Here's the code I'm trying to execute:
> > <cfquery name="createTable" datasource="#db#">
> > CREATE TempTable AS
> >
> > (SELECT ENGINEER_SKILLS_ENGINEERS.ES_ENGINEERS_ID,
> > ENGINEER_SKILLS_SKILLSET.SKILLSET_ID,
> > ENGINEER_SKILLS_PROGRAMS.PROGRAM_ID,
> > ENGINEER_SKILLS_CERTIFICATION.CERTIFICATION_ID,
> > ENGINEER_SKILLS_TRAINING.TRAINING_ID
> > FROM ENGINEER_SKILLS_ENGINEERS
> > INNER JOIN ENGINEER_SKILLS_SKILLSET ON
> > ENGINEER_SKILLS_SKILLSET.USR_USER_ID =
> ENGINEER_SKILLS_ENGINEERS.USR_USER_ID
> > LEFT JOIN ENGINEER_SKILLS_PROGRAMS ON
> > ENGINEER_SKILLS_PROGRAMS.SKILLSET_ID = ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> > LEFT JOIN ENGINEER_SKILLS_CERTIFICATION ON
> > ENGINEER_SKILLS_CERTIFICATION.SKILLSET_ID =
> > ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> > LEFT JOIN ENGINEER_SKILLS_TRAINING ON
> > ENGINEER_SKILLS_TRAINING.SKILLSET_ID = ENGINEER_SKILLS_SKILLSET.SKILLSET_ID
> > WHERE ES_ENGINEERS_ID = 1)
> > </cfquery>
> >
> > This code runs just find when I copy and paste into SQL Plus, but when
> I put
> > it in a cfquery tag, I get the following error:
> >
> > Error Executing Database Query. [Macromedia][Oracle JDBC
> > Driver][Oracle]ORA-00901: invalid CREATE command
> >
> > I find it interesting that I'm not getting a Coldfusion error, which leads
> > me to believe that I *should* be able to run this code. Or am I just
> > crazy?________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
