9 Replies Latest reply on Jan 24, 2013 10:07 AM by 986600

    Application creation error

      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

          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

          1 person found this helpful
          • 2. Re: Application creation error
            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
              Where should I type these query - i mean to say should I do it in my Workspace sql commands ?
              • 4. Re: Application creation error

                yes, you should type this query on your DB

                • 5. Re: Application creation error
                  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
                    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.

                    • 7. Re: Application creation error

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

                      • 8. Re: Application creation error
                        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
                          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