 	<cfset loc.dateTimeColumnType = "timestamp">
 	<cfset loc.binaryColumnType = "bytea">
 <cfelseif loc.db IS "oracle">
-	<cfset loc.identityColumnType = "int NOT NULL">
+	<cfset loc.identityColumnType = "number(38,0) NOT NULL">
 	<cfset loc.dateTimeColumnType = "timestamp">
-	<cfset loc.textColumnType = "long">
+	<cfset loc.textColumnType = "varchar2(4000)">
+	<cfset loc.intColumnType = "number(38,0)">
 	<cfset loc.dateTimeDefault = "to_timestamp(#loc.dateTimeDefault#,'yyyy-dd-mm hh24:mi:ss.FF')">
 </cfif>
 

	,description="testdesc"
)>

<cfquery name="loc.query" datasource="#application.wheels.dataSourceName#">
INSERT INTO collisiontests (method)
VALUES ('test')
</cfquery>
CREATE TABLE cities
(
	countyid char(4) NOT NULL
	,citycode #loc.intColumnType# NOT NULL
	,name varchar(50) NOT NULL
	,PRIMARY KEY(countyid,citycode)
) #loc.storageEngine#
