2 Replies Latest reply: Apr 17, 2008 10:11 PM by 634536 RSS

    About ilma_demo_install

    634536
      Lilian:

      How to set the parameter nls_date_format? There are a lot of mistakes when i run the script ilma_demo_install (version 1.2)?

      SQL> insert into ilm_demo.calendar values ('1-JAN-2003');
      insert into ilm_demo.calendar values ('1-JAN-2003')
      *
      第 1 行出现错误:
      ORA-01858: 在要求输入数字处找到非数字字符

      thanks.

      James/2008-4-15
        • 1. Re: About ilma_demo_install
          634536
          The point is language ,set the parameter NLS_LANGUAGE resolve the problem.
          alter session set NLS_LANGUAGE=AMERICAN;
          then run the script.No error hapens again.

          Thanks for your concern.

          James/2008.4.18
          • 2. Re: About ilma_demo_install
            634536
            Lilian:
            There is another error when i install ilma_demo_install.sql.Detail for below:

            ********************************************************
            Creating managed table entries for rule General Orders ...
            ********************************************************

            PL/SQL procedure successfully completed.

            ORA-00904: "COMPRESS_FOR": invalid identifier ... skipping ILM_DEMO.PART_ORDERS table

            What's the reason?

            Environment:
            apex 2.2
            oracle 11G r1
            ilm assistant 1.2

            James/2008-4-17