This content has been marked as final. Show 9 replies
hi,1 person found this helpful
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:
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
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.
Where should I type these query - i mean to say should I do it in my Workspace sql commands ?
yes, you should type this query on your DB
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
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.
when you deleted unwanted application, required component called IS_VALID_APPLICATION_NAME was deleted unfortunately.
you should compile tihs procedure from old application.
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
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