Re: Using run_product in Forms 4.0

In article <47rmbb$k7v_at_enterprise.sct.gu.edu.au>, terence_at_cit.gu.edu.au_ says...
>
>Hello. I am running Forms 4.0 and Reports 2.0 on a PC and Oracle 7.1.4 for
 Solaris 2.4
>which the PC connects to via SQL*Net v2.
>
>I have a problem with running reports that have been saved to the database.
>When I use the run_product function, I get the following errors:
> REP-0110: Unable to open file 'AIRL'
> REP-1070: Object store failure occurred.
>I am calling a report called AIRL from forms using the following,
> run_product(REPORTS,'AIRL',SYNCHRONOUS,RUNTIME,DB,parm_list,null);
>
>According to the manual, the DB option is supposed to tell Reports to go and
 look
>in the database for the report. However, it doesn't seem to do this. It still
 seems
>to still try to look for a file.
>
>Does anyone use this feature and have got it to work for reports stored in
the database? If not, is there any other way of running reports from the databa
>
>Any help would be greatly appreciated.
>
>
>--
>Terence Chew Computing Support Section
>T.Chew_at_cit.gu.edu.au Faculty of Computing and Information Technology
>Ph: +61 7 3875 5421 Griffith University
>Fax: +61 7 3875 5425 Nathan, Brisbane, Queensland, Australia 4111
>
>

Hi,

I'm not sure exactly what the problem is, but there a couple of things that may help.
Make sure that the path in the Oracle.ini file is pointing to the right place for the reports -
reports2.0_path = ....
and also that there you have a temporary directory set up on the PC with plenty of space.
Also, if the reports are on the database, make sure that you have write access to the directory they
are stored in.(I tripped up on all these points!)