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]
