9 Replies Latest reply: Jan 24, 2013 4:07 AM by 986600 RSS

    Application creation error

    986600
      Dear all,

      I am trying to build an application in the Oracle APEX , but it show me error saying:

      ORA-06550: line 1, column 71: PLS-00302: component 'IS_VALID_APPLICATION_NAME' must be declared ORA-06550: line 1, column 45: PL/SQL: Statement ignored

      Earlier it was fine and I was able to create one. But suddenly after deleting my old and unwanted applications, I am not able to create a new one.

      please help me in this regard.

      thank you
        • 1. Re: Application creation error
          dataseven
          hi,

          The Oracle docs note the following on PLS-00302:

          PLS-00302: component "string" must be declared

          Cause: In a reference to a component (for example, in the name "A.B", "B" is a component of "A"), the component has not been declared. The component might be misspelled, its declaration might be faulty, or the declaration might be placed incorrectly in the block structure.

          Action: Check the spelling and declaration of the component. Also confirm that the declaration is placed correctly in the block structure.



          select status from dba_objects where object_name = 'IS_VALID_APPLICATION_NAME' ;

          If it is INVALID do the following:

          As apps,
          alter package IS_VALID_APPLICATION_NAME compile;

          If this comes back with a warning or is still invalid:

          select * from dba_errors where object_name = 'IS_VALID_APPLICATION_NAME' ;

          you can trace this session

          alter session set sql_trace=true;

          run the declare

          alter session set sql_trace=false;

          maybe while you deinstall old application, you may delete needed component
          try statements above

          regards,
          • 2. Re: Application creation error
            BluShadow
            I've moved your question to the "Oracle Discussion Forums » Oracle Database » Application Express" forum as it doesn't belong in the SQL and PL/SQL forum.
            • 3. Re: Application creation error
              986600
              Where should I type these query - i mean to say should I do it in my Workspace sql commands ?
              • 4. Re: Application creation error
                dataseven
                hi,

                yes, you should type this query on your DB

                regards,
                • 5. Re: Application creation error
                  986600
                  Actually, I have purchased a workspace, and there I am occurring with this error. When I type these queries which you have specified in the sql commands, I get the
                  1)select status from dba_objects where object_name = 'IS_VALID_APPLICATION_NAME' ;
                  result: ORA-00942: table or view does not exist

                  2)alter package IS_VALID_APPLICATION_NAME compile;

                  result:ORA-04043: object IS_VALID_APPLICATION_NAME does not exist

                  3)alter session set sql_trace=true;
                  result: ORA-01031: insufficient privileges

                  4)alter session set sql_trace=false;
                  ressult: ORA-01031: insufficient privileges

                  I am not able to configure them. please help
                  • 6. Re: Application creation error
                    joelkallman-Oracle
                    Hi there,

                    Are you able to share where this workspace is at? IS_VALID_APPLICATION_NAME is a function in one of the APEX-supplied internal packages.

                    Joel
                    • 7. Re: Application creation error
                      dataseven
                      hi,

                      when you deleted unwanted application, required component called IS_VALID_APPLICATION_NAME was deleted unfortunately.
                      you should compile tihs procedure from old application.

                      regards,
                      • 8. Re: Application creation error
                        986600
                        hi,
                        actually I had made a new login function for a dynamic login from my database. I had run that function from a script. Later when I accounted with this problem I deleted it. Now I dont have that function. Can you please provide me that function, and please guide how to run that function. I have purchased workspace at www.bestapexhost.com
                        • 9. Re: Application creation error
                          986600
                          hi,
                          The only old application left in my workspace is the default one, i.e. Sample database application. How should I retrieve that function from it? Please help