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.
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
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
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