10 Replies Latest reply: May 5, 2014 6:49 AM by Pramod SR RSS

    Automatic recompile of procedure body failed while compiling forms

    Pramod SR

      Hi all,

       

      I am getting the error 'automatic recompile of procedure body failed' (Internal error also) while compiling the form. I came across many threads but none of the links resolved my issue. I am using Oracle developer suite 10g, DB 10g and Windows OS. I am referring one package from 'AAA' schema(VALID state), form is connected to same schema but i am getting error while compiling. I reconnected from form builder, recompiled the package as suggested by many links, still facing the same problem. Please help.

       

      Thanks,

      Pramod

        • 1. Re: Automatic recompile of procedure body failed while compiling forms
          sfr.farhan

          Hi,

           

          Do you have any procedure based block in your form? if yes then rerun the data block wizard one more time.

          Do you have any library attach with your form? compile it again.

          • 2. Re: Automatic recompile of procedure body failed while compiling forms
            Pramod SR

            Hi sfr.farhan.fani,

             

            Thanks for your time. One block is based on view there is no procedure based block in my form. I have compiled the libraries attached to the form as you suggested but no change. I dont think it is related to a particular procedure in a package because i am calling around 5-6 procedures from the same package, i noticed that all the procedures are giving the same error as i mentioned above.

             

            Thanks,

            Pramod

            • 3. Re: Automatic recompile of procedure body failed while compiling forms
              sfr.farhan

              Did you try to compile with the following commands

               

              1. frmcmp userid=us/pw@tns module=<form_name>.fmb batch=yes module_type=form compile_all=yes window_state=minimize

              2. Ctrl + K

              3. Shift + Ctrl + K

              4. Ctrl + T

               

              After compile, is there any error in <form_name>.err file?

              • 4. Re: Automatic recompile of procedure body failed while compiling forms
                Pramod SR

                Hi sfr.farhan.fani,

                 

                Below is the error generated.

                Compiling package specification BARCODE...

                   No compilation errors.

                 

                 

                Compiling procedure DISP_MSG...

                   No compilation errors.

                 

                 

                Compiling package body BARCODE...

                   No compilation errors.

                 

                 

                Compiling procedure UPLOAD_CLIENT_FILE...

                   No compilation errors.

                 

                 

                Compiling procedure CHECK_PRIVILEGES...

                   No compilation errors.

                 

                 

                Compiling procedure AAA_REVISION_HISTORY...

                   No compilation errors.

                 

                 

                Compiling procedure CENTER_POS_WINDOW...

                   No compilation errors.

                 

                 

                Compiling WHEN-NEW-FORM-INSTANCE trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-ENTQRY trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-EXEQRY trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-DELREC trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-UPDREC trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-CREREC trigger on form...

                   No compilation errors.

                 

                 

                Compiling ON-ERROR trigger on form...

                   No compilation errors.

                 

                 

                Compiling CLRFRM trigger on form...

                   No compilation errors.

                 

                 

                Compiling WHEN-WINDOW-CLOSED trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-CLRFRM trigger on form...

                   No compilation errors.

                 

                 

                Compiling KEY-COMMIT trigger on form...

                   No compilation errors.

                 

                 

                Compiling PRE-QUERY trigger on BARCODE_VARIANT_V data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-NEW-RECORD-INSTANCE trigger on BARCODE_VARIANT_V data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CHECKBOX-CHANGED trigger on CHK_BARCODE item in BARCODE_VARIANT_V data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on MODIFIEDON item in BARCODE_VARIANT_V data block...

                   No compilation errors.

                 

                 

                Compiling KEY-DOWN trigger on CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-UP trigger on CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-CLRREC trigger on CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on BRAND_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on BRAND_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on BRAND_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on ADD item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on ADD item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on REMOVE item in CONTROL data block...

                Compilation error on WHEN-BUTTON-PRESSED trigger on REMOVE item in CONTROL data block:

                PL/SQL ERROR 801 at line 1, column 1

                internal error [60603]

                PL/SQL ERROR 0 at line 43, column 16

                Statement ignored

                 

                 

                Compiling KEY-NEXT-ITEM trigger on REMOVE item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on SEARCH_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on SEARCH_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on UPLOAD item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on DOWNLOAD item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on DOWNLOAD item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on BARCODE item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on OK item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on OK item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on CANCEL item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on CANCEL item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on DOWNLOAD_OK item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on DOWNLOAD_CANCEL item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on DOWNLOAD_CANCEL item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H1_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H1_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H2_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H2_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H3_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H3_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H4_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H4_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H5_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H5_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H6_DESC item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on H6_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on H6_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on FIND_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling KEY-NEXT-ITEM trigger on FIND_BUT item in CONTROL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-BUTTON-PRESSED trigger on DUMMY item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_CLIENTINFO_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_FILE_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_HOST_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_SESSION_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_FILETRANSFER_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_OLE_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_C_API_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compiling WHEN-CUSTOM-ITEM-EVENT trigger on WEBUTIL_BROWSER_FUNCTIONS item in WEBUTIL data block...

                   No compilation errors.

                 

                 

                Compilation errors have occurred.

                • 5. Re: Automatic recompile of procedure body failed while compiling forms
                  994122

                  Hi Pramod,

                   

                  Compiling WHEN-BUTTON-PRESSED trigger on REMOVE item in CONTROL data block...

                  Compilation error on WHEN-BUTTON-PRESSED trigger on REMOVE item in CONTROL data block:

                  PL/SQL ERROR 801 at line 1, column 1

                  internal error [60603]

                  PL/SQL ERROR 0 at line 43, column 16

                  Statement ignored

                   

                  Means check your code (WBP) carefully.

                   

                  (OR)


                  Also check Problem comes when calling programs in .pll files.

                   

                   

                   

                  *****

                  I think this error is caused when u make some changes in the form after either changing the table design at the back end(database block) or the connectivity to the server is disconnected for some time and u reconnect and compile.

                  for this come out of forms reconnect and compile all using shift+control+k. then this internal error will be gone

                  ******

                   

                  And use

                  frmcmp_batch userid=apps/apps module=XXC_EMP.fmb output_file=XXC_EMP.fmx module_type=form batch=no compile_all=yes to compile the form

                  • 6. Re: Automatic recompile of procedure body failed while compiling forms
                    Pramod SR

                    Hi,

                     

                    Thanks for you time. There is a bock based on view in the form. I added 2 columns to that view in DB but i have not added those columns in the block as i am not referring the new columns anywhere but i am referring them in PRE-QUERY like this. (part_number is newly added), :CONTROL.part_number_search is control item.

                     

                    l_where := 'brand = '||''''||:CONTROL.brand||'''';

                     

                      IF :CONTROL.part_number_search IS NOT NULL THEN

                           l_where := l_where||' AND part_number = '||''''||:CONTROL.part_number_search||'''';

                      END IF;

                     

                    set_block_property('BARCODE_VARIANT_V', default_where, l_where);

                     

                    I don't feel this will cause any issue in my case.

                     

                    Thanks,

                    Pramod

                    • 7. Re: Automatic recompile of procedure body failed while compiling forms
                      994122

                      Hi Pramod ,

                       

                        Please Try this once..

                       

                      DECLARE

                          dfinalstr VARCHAR2(5000);

                          QT        VARCHAR2(10) := '''';

                      BEGIN

                          l_where := 'brand = ' ||QT ||:CONTROL.brand ||QT;

                       

                       

                          IF :CONTROL.part_number_search IS NOT NULL THEN

                              l_where := l_where ||' AND part_number = ' ||QT ||:CONTROL.part_number_search ||QT;

                          END IF;

                       

                          Go_block('DATABASE_BLOCK');

                       

                          dfinalstr := Get_block_property('DATABASE_BLOCK', default_where);

                       

                          Set_block_property('BARCODE_VARIANT_V', default_where, l_where);

                      END;

                      • 8. Re: Automatic recompile of procedure body failed while compiling forms
                        994122

                        Hi Pramod

                        Please check the below link ...http://www.wiki-errors.com/err.php?wiki=801

                         

                        (or)

                         

                        Check your package calling or procedure then reconnect ,then recompile.

                         

                        (or)

                         

                        Check your database schema or package schema

                        • 9. Re: Automatic recompile of procedure body failed while compiling forms
                          Pramod SR

                          Hi All,

                           

                          Issue got resolved. In package spec i have used one variable like this

                          g_user_id VARCHAR2(20) := NVL(dw_jobs.g_userid, USER);

                          where dw_jobs package itself was not there. Thanks for your support Smile


                          I have a question, why oracle is not throwing error while compiling package?

                          • 10. Re: Automatic recompile of procedure body failed while compiling forms
                            Pramod SR

                            Hi All,

                             

                            Let me correct my comments above.

                            dw_jobs

                            package is in another schema and we have a privilege to execute it. I noticed that our DB is migrated from 10g to 11g. I just moved the declaration of the variable to package body and the problem got resolved. I did not understand the reason behind that.