| Problem in running report from forms 6i.......Please help...! [message #265779] |
Fri, 07 September 2007 06:38  |
james_aron
Messages: 32
Registered: July 2007
Location: chennai
|
Member |
|
|
hi all,
I am working in oracle forms 6i and i am trying to run report from form while press one of the push-button. works fine upto 2nd line from the begin key-word.After that its showing error like " FRM-40738:Argument 1 to builtin REPORT_OBJECT_STATUS cannot be null.". Can any-one help me of how to solve this and
wat would be the problem.........?
declare
run_rep varchar2(200);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('report46');
run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);
if rep_stat = 'FINISHED' then
copy_report_object_output(run_rep, 'C:\Documents and Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
end;
Please help asup!
regards,
jame
[Updated on: Fri, 07 September 2007 07:12] Report message to a moderator |
|
|
|
|
|
| Re: Problem in running report from forms 6i.......Please help...! [message #265789 is a reply to message #265787] |
Fri, 07 September 2007 07:11  |
james_aron
Messages: 32
Registered: July 2007
Location: chennai
|
Member |
|
|
Sorry small mistake, forget to change the name v_rep to run_rep...
declare
run_rep varchar2(200);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('report46');
run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);
if rep_stat = 'FINISHED' then
copy_report_object_output(run_rep, 'C:\Documents and Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
end;
Please help asup!
[Updated on: Fri, 07 September 2007 07:13] Report message to a moderator |
|
|
|
|
|
| Re: Problem in running report from forms 6i.......Please help...! [message #266645 is a reply to message #266507] |
Tue, 11 September 2007 05:17 |
james_aron
Messages: 32
Registered: July 2007
Location: chennai
|
Member |
|
|
hi david,
Below is my code, everything is fine except report_object_status.......
declare
run_rep varchar2(2000);
rep_obj report_object;
rep_stat varchar2(20);
begin
rep_obj := find_report_object('REPORT48');
set_report_object_property(rep_obj,REPORT_DESTYPE,FILE);
set_report_object_property
rep_obj,REPORT_DESNAME,'c:\Testing.pdf');
set_report_object_property(rep_obj,REPORT_DESFORMAT,'PDF');
run_rep := run_report_object(rep_obj);
rep_stat := report_object_status(run_rep);
/*if rep_stat = 'FINISHED' then
message('report completed');
copy_report_object_output(run_rep, 'C:\Documents and
Settings\trainee\Desktop\Icons\test.pdf');
else
message('error when running report');
end if;
*/
end;
Could u tell me y it is storing null value in rep_stat. Programe error or system error..?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
