-
1. Re: issue about passing date values between forms / reports using RUN_REPORT_OBJECT
Well, before I start guessing at the possible cause - I strongly suggest you post the full error message you are getting. Without the full error message, all you're going to get is a bunch of wild-guesses.
Craig...
-
2. Re: issue about passing date values between forms / reports using RUN_REPORT_OBJECT
When you're using the add_parameter command to add parameters to the paramlist what data type of parameter are you using for the date parameter(s)?
-
3. Re: issue about passing date values between forms / reports using RUN_REPORT_OBJECT
i have a generic procedures that have worked for me on 6i / 11g:
for r_par in (select nb_alias
,co_item_proceso
,nb_referencia
,id_registro
from s00_item_proceso_r
where pro_co_proceso = p_co_reporte
and ctv_co_tipo_item_proceso = 'RP'
order by nu_ordenamiento) loop
if r_par.nb_referencia is not null
then
v_va_parametro := name_in ('control1.'||r_par.nb_referencia);
else
if instr(r_par.nb_alias,'|') = 0 then
v_va_parametro := name_in('control1.'||r_par.nb_alias);
else
v_longitud := instr(r_par.nb_alias,'|');
v_va_parametro := name_in('control1.'||substr(r_par.nb_alias,1,v_longitud -1));
end if;
end if;
--
add_parameter(v_pl_id,r_par.co_item_proceso,text_parameter,v_va_parametro);
end loop;
-
4. Re: issue about passing date values between forms / reports using RUN_REPORT_OBJECT
So, you are passing your date as a text parameter with this code, and I guess that the date format it is arriving to in reports is not the date format that the reports code is expecting.
rgds
Tony