3 Ответы Последний ответ: 07.07.2016 10:42, автор: Dan Andro-Oracle

    ORA-01041: internal error. hostdef extension doesn't exist  in forms 12c

    3269571

      I have migrated forms from 5.5 to 12c. First change to 6i and then pass the forms to 12c, with the Forms Migration Assistant.

      I have a problem with a form, I have compilation error ORA-01041: Internal error. hostdef extension doesn´t exist.

      This error is produced because I have some variables in section declare of a program unit, procedure, that references to tables with a dblink access. In the text of the program unit I have calls to packages of other database and the conection is through a dblink.

      If I comment the code lines the form and the program unit compile fine.

      What can I do? I try to avoid creating a module pl/sql in BBDD and call it.

      It possible to access to objects with dblink on forms 12c?

       

      Thanks for the help!

        • 1. Re: ORA-01041: internal error. hostdef extension doesn't exist  in forms 12c
          Kalpataru

          Are you sure you are connecting to same database which have the database link object exists ?

          Try to compile all the form Shift + Ctrl + K  and check that you are connecting to the correct database.

          Can you post the code ?

          • 2. Re: ORA-01041: internal error. hostdef extension doesn't exist  in forms 12c
            3269571

            I don´t use the database link directly. The database link was created on BBDD, and synonyms for the objects that I will use.

            And it seems that forms don´t recognize it.

             

            This is the code of the database link:

            -- Create database link

            create database link E73CP00.WORLD

              connect to L_TGCPRT10

              using 'DESA_SCP';

             

            This is the code of the synonym:

            -- Create the synonym

            create or replace synonym CPCRT_QOPERACIONADSL

              for CPCRT_QOPERACIONADSL@E73CP00.WORLD;

             

            In the form I have a Program Unit, is a procedure, and I declare a variable like this, in the declare section:

            v_error_scp          CPCRT_QOPERACIONADSL.R_ERROR;

             

            In the moment that I put the line declarating the variable I have the error, If I try to call the package in code section I obtain the error too.

            When I compile Ctrl + Shift + K: Compilation Complete Succesfully

            But the program units, all of the form, have the error:

            Error at line 0, column 0

            ORA-01041: internal error. hostdef extension doesn´t exists

             

             

            If is necessarie more information tell me please.

             

            Thanks for th help!

            • 3. Re: ORA-01041: internal error. hostdef extension doesn't exist  in forms 12c
              Dan Andro-Oracle

              Hello,

               

              What database versions are you using?

              Also, can you try the following?

              1. Create a view of the dblink table

              2. Test you can successfully select from the view

              3. Use this view in the Forms instead of remoteDB table

              4. Now compile and test the form

               

              Regards,

              Dan