This discussion is archived
9 Replies Latest reply: Jan 24, 2013 2:07 AM by 986600 RSS

Application creation error

986600 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Guru Moderator
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    hi,

    yes, you should type this query on your DB

    regards,
  • 5. Re: Application creation error
    986600 Newbie
    Currently Being Moderated
    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
    jkallman Employee ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points