Oracle Reports

oraforum · #1 (**permalink**) 08-03-04, 18:07

Hi,
I would like to know how to run an Oracle Report from Oracle forms 9i.I tried to use RUN_REPORT_OBJECT but its giving me errors could any one give me the correct syntax and the procedure as how to run the report from oracle forms 9i.
Please reply to me.

Thanks
Oraforum

anacedent · #2 (**permalink**) 08-03-04, 19:06

>its giving me errors
Stop & think.
We (TINW) are NOT minders.
Do you realize how many HUNDREDS of different errors there are?
Each different error requires a different solution.
Form 9i is less than helpful.
What's the actual version number out to four digits?
EXACTLY & COMPLETELY how are you trying to invoke Reports 9i?

da!sy · #3 (**permalink**) 09-07-04, 02:29

hi,
I'm also having errors in calling a report using the following code:

Code:

DECLARE
	RID REPORT_OBJECT;
	RNAME VARCHAR2(100);
BEGIN
	:SYSTEM.MESSAGE_LEVEL := 5;
	RID := FIND_REPORT_OBJECT('cakes');
	RNAME := RUN_REPORT_OBJECT(RID);
	:SYSTEM.MESSAGE_LEVEL := 0;
END;

I'm now at a different computer which has no Oracle package downloaded, so the errors were shown in 2 alert boxes, first says that the run_report_object couldn't be called, and the second telling something about 1 argument (sorry for my embeguice errorsm this is what I could remember)
considering that I had called a report before from the same computer.

thnks

Internet Services

Web Development

Digital Marketing

Consumer Tech