Advertisement
mugs

ORA-00911: invalid character

Feb 3rd, 2016
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.76 KB | None | 0 0
  1. [ERROR] Failed TO EXECUTE goal org.liquibase:liquibase-maven-plugin:3.2.0:UPDATE (update-rice) ON project kfs-data: Error setting up OR running Liquibase: Migration failed FOR change SET liquibase/rice/data.xml::NWUKFS-2724::za-kfs:
  2. [ERROR] Reason: liquibase.EXCEPTION.DatabaseException: Error executing SQL DELETE FROM FP_SEQUENCE_T WHERE DOC_TYP = 'KREW_DOC_HDR_S';
  3. [ERROR] DECLARE
  4. [ERROR] max_sequence_value INTEGER;
  5. [ERROR] BEGIN
  6. [ERROR] SELECT NVL(MAX(TO_NUMBER(DOC_HDR_ID)), 1) + 1
  7. [ERROR] INTO max_sequence_value
  8. [ERROR] FROM KREW_DOC_HDR_T;
  9. [ERROR] EXECUTE IMMEDIATE 'insert into FP_SEQUENCE_T (DOC_TYP, NEXT_SEQ_NBR, VER_NBR) values (''KREW_DOC_HDR_S'', '  || max_sequence_value || ' , 1)' ;
  10. [ERROR] END;: ORA-00911: invalid character
  11. [ERROR] -> [Help 1]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement