Skip to content

Oracle - Cannot create table that contains a column named "DELIMITER" #2

Open
@JustinPealing

Description

@JustinPealing

Running the following script against an Oracle database:

CREATE TABLE "FOO" 
(
    "DELIMITER" VARCHAR2(30 BYTE)
);

Fails with this error:

Oracle exception has occured in script: '001_TABLES.sql'
Oracle error code: 0; Number -2147467259; Message: 904
Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904: : invalid identifier
   at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()
   at DbUp.Oracle.OracleScriptExecutor.ExecuteCommandsWithinExceptionHandler(Int32 index, SqlScript script, Action excuteCommand)

Looks like it something to do with this? https://github.com/DbUp/DbUp/blob/e874234e8d320dc37c272e5137092da0b89d72f3/src/dbup-oracle/OracleCommandReader.cs#L9

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    Status

    Bugs

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions