liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE EXAMPLE (ID NUMBER(0,-127)): ORA-01727: numeric precision specifier is out of range (1 to 38)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via JIRA by Andy Goossens, 1 year ago
Error executing SQL CREATE TABLE EXAMPLE (ID NUMBER(0,-127)): ORA-01727: numeric precision specifier is out of range (1 to 38)
via JIRA by Andy Goossens, 1 year ago
Error executing SQL CREATE TABLE EXAMPLE (ID NUMBER(0,-127)): ORA-01727: numeric precision specifier is out of range (1 to 38)
via JIRA by Ross Attrill, 1 year ago
Error executing SQL CREATE TABLE ACTION (ACTION_ID INTEGER CONSTRAINT ACTION_PK PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, ACTION TEXT NOT NULL, ACTION_SOURCE_CODE TEXT NOT NULL): [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
via JIRA by Ross Attrill, 1 year ago
Error executing SQL CREATE TABLE ACTION (ACTION_ID INTEGER CONSTRAINT ACTION_PK PRIMARY KEY AUTOINCREMENT AUTOINCREMENT NOT NULL, ACTION TEXT NOT NULL, ACTION_SOURCE_CODE TEXT NOT NULL): [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)
via liquibase.org by Unknown author, 2 years ago
Error executing SQL CREATE  TRIGGER IS_PI_AFTER_UPDATE     AFTER UPDATE     ON USERS     FOR EACH ROW     DECLARE     BEGIN         IF (:OLD.IS_PI != :NEW.IS_PI) THEN               IF(:NEW.IS_PI = 'true') THEN                  INSERT INTO
liquibase.exception.DatabaseException: Error executing SQL CREATE TABLE EXAMPLE (ID NUMBER(0,-127)): ORA-01727: numeric precision specifier is out of range (1 to 38)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
at liquibase.Liquibase.update(Liquibase.java:114)
at liquibase.integration.commandline.Main.doMigration(Main.java:825)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 5 months ago
579 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.