Failed to load the following object in oracle forms

[nramrits]

when i open form in a developer i'm getting err
FRM-18108:faild to load a following objects.
Source Module : PROG_UNIT.olb
Source Object : PROC_RUN_REPORT
this error comes perticular forms only , all other forms are working fine.

pls anyone help me...

[amitpatel66]

when i open form in a developer i'm getting err
FRM-18108:faild to load a following objects.
Source Module : PROG_UNIT.olb
Source Object : PROC_RUN_REPORT
this error comes perticular forms only , all other forms are working fine.

pls anyone help me...

Check if the procedure PROC_RUN_REPORT exists in the database that is used by the forms and is in VALID status.

[code=oracle]

SELECT * from all_objects where object_name LIKE 'PROC_RUN_REPOR T'

[/code]

[nramrits]

Check if the procedure PROC_RUN_REPORT exists in the database that is used by the forms and is in VALID status.

[code=oracle]

SELECT * from all_objects where object_name LIKE 'PROC_RUN_REPOR T'

[/code]

LIVE> SELECT * FROM all_objects WHERE object_name LIKE '%PROC_RUN_REPO RT%';

no rows selected

it will return no rows selected.but some forms are working fine .
how..

[amitpatel66]

LIVE> SELECT * FROM all_objects WHERE object_name LIKE '%PROC_RUN_REPO RT%';

no rows selected

it will return no rows selected.but some forms are working fine .
how..

Ok. Here is what you need to check:

open an fmb that works fine, then in SEARCH box, enter this procedure name and click on find. If it has this proc, then it will point to that.

Then open the FMB that is displaying thie error and do the same. Check that it should not have this procedure implemented in it.

[nramrits]

Ok. Here is what you need to check:

open an fmb that works fine, then in SEARCH box, enter this procedure name and click on find. If it has this proc, then it will point to that.

Then open the FMB that is displaying thie error and do the same. Check that it should not have this procedure implemented in it.

search is completed but no results..
and another one important news i can't use this procedure in
forms and object libraries.but it will raise again again

any another way..pls help me..

[amitpatel66]

search is completed but no results..
and another one important news i can't use this procedure in
forms and object libraries.but it will raise again again

any another way..pls help me..

If you have a look at this error, it sayd PROG_UNIT.olb which means program unit. Program Unit is the heading in the FMB file under which all the function and procedure resides. Some or the other function might be giving a call to a procedure which does not exist in the FMB thus, this error.

[nramrits]

search is completed but no results..
and another one important news i can't use this procedure in
forms and object libraries.but it will raise again again

any another way..pls help me..

actually the object library PROG_UNIT have a three procedures namelly
RUN_REPORT,
PROC_RPT_PARAM,
CHECK_DATA .but PROC_RUN_REPORT is not there then why it will be raise.