Is it possible to execute code that creates a temporary table using a cfquery tag?
Here's the code I'm trying to execute:
CREATE TempTable AS
(SELECT ENGINEER_SKILLS_ENGINEERS.ES_ENGINEERS_ID,
ENGINEER_SKILLS_SKILLSET.SKILLSET_ID,
ENGINEER_SKILLS_PROGRAMS.PROGRAM_ID,
ENGINEER_SK
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
The syntax is wrong. It should be CREATE TABLE TempTable.
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
>i
3 matches
Mail list logo