Oracle is case aware if you put the table names in quotes,
but not otherwise (I think).
And "systemTables" could be reserved, perhaps. Dunno offhand.
Does everything have to be quoted? You tried just the table name?
Reserved words is the only other thing I can think of...
On 3/8/07, Dawn Sekel wrote:
>
> I am trying to transfer an application from MSAccess into Oracle 10g. I
> the free version of Oracle 10g Express running locally for development
> purposes before uploading to the test server. I have used older versions of
> Oracle, but never 10g. It has been a while, but I do not ever remember
> having to put everything in quotes before. However, the only way I can get
> table creates and record inserts to work is by putting everything in quotes
> including the table name. When I look at examples of other Oracle SQL on
> the Internet, I'm not seeing this format. Is what I am experiencing correct
> or is there some setting I don't know about? Thanks in advance for any
> advice. This is the query I have gotten to work.
>
> <cfquery name="tableCreate" datasource="#session.systemTables#">
> CREATE table "systemRoles" (
> "roleID" NUMBER,
> "description" VARCHAR2(50),
> "viewable" NUMBER,
> "help" VARCHAR2(256),
> "createdDate" DATE,
> "createdBy" NUMBER,
> "modifiedDate" DATE,
> "modifiedBy" NUMBER,
> constraint "systemRoles_PK" primary key ("roleID")
> )
>
> </cfquery>
> <http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=20754.16073.4>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
