OPEN_FORM Forms v6i

[hpaille]

Hi,

I'd like to use the OPEN_FORM function in forms V6i but it returns the error ORA-01403 No data found.
Here is the code:
DECLARE
liste_parametre PARAMLIST;
BEGIN
IF NOT (Id_null(liste_parametre)) THEN
DESTROY_PARAMETER_LIST('param_list');
END IF;
liste_parametre:=Create_parameter_list('param_list');
||' '|| :NDT_ALERT.MAT_GERANT ||' '|| :NDT_ALERT.NUM_FOURN);
ADD_PARAMETER(liste_parametre,'PRM_COD_PDV',TEXT_PARAMETER,:NDT_ALERT.COD_PDV);
ADD_PARAMETER(liste_parametre,'PRM_COD_GERV',TEXT_PARAMETER,:NDT_ALERT.MAT_GERANT);
ADD_PARAMETER(liste_parametre,'PRM_NUM_FOUR',TEXT_PARAMETER,:NDT_ALERT.NUM_FOURN);
GESTION_ALERTENDT_ALERT.COD_PDV ||' '|| :NDT_ALERT.MAT_GERANT ||' '|| :NDT_ALERT.NUM_FOURN);
OPEN_FORM('NDT_RAPPRO02.fmx','ACTIVATE','NO_SESSION',liste_parametre);

I guess the OPEN_FORM function cannot find the program NDT_RAPPRO02.fmx, but I don't understand why.
Any suggestions ?

 

[sem]

I don't think that form absence may cause NO_DATA_FOUND Try to catch it before, namely in GESTION_ALERTE procedure. BTW, is that form location listed in FORMS60_PATH?

Regards, Dima

http://seminihin.narod.ru

 

[hpaille]

The GESTION_ALERTE procedure works fine and is there only in a debug purpose. I have removed the OPEN_FORM call and the message disappeared. I also tried to put both .fmx and .fmb in the FORMS60_PATH, but still had the same message...

 

[sem]

Try to investigate that NDT_RAPPRO02 form further. This error may be raised by its WHEN-NEW-FORM-INSTANCE or other startup trigger. Or by some navigation trigger of calling form. In any case OPEN_FORM doesn't raise this error.

Regards, Dima

http://seminihin.narod.ru

 

[hpaille]

The problem was the quotes around ACTIVATE and NO_SESSION... The error message was not what I would call very useful !!