| Reports are not connecting to the database [message #563484] |
Tue, 14 August 2012 05:39  |
 |
daisy78
Messages: 9
Registered: August 2012
|
Junior Member |
|
|
I have an oracle related question for you.
I am running a OC4J instance on my laptop, so that I can test out oracle forms
I can login to the applications and forms runs ok.
On one of the forms there is a button to run an oracle report from that form.
When I run the report is fails. I have put tracing on the report engine and it is failing as it cannot connect to the database.
I have also put tracing in sqlnet.ora
When I originally login to the application via oracle forms it puts data in the trace file, but when I try and run the report no data goes to the sqlnet.ora trace file.
Do you know why the oracle report does not connect to the database and / or why there is nothing in the sqlnet trace file for the report.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Reports are not connecting to the database [message #563837 is a reply to message #563831] |
Fri, 17 August 2012 07:20  |
|
daisy78
Messages: 9
Registered: August 2012
|
Junior Member |
|
|
Hi, Basically below is how we run the report, the internal oracle code should be able to work out the connection string as the report is already connected and in the trace output of the report engine it has the correct username and database name (but no password - I assume for security purposes)
PROCEDURE RunReport IS
rep_name varchar2(9) := 'TESTRPT';
repid REPORT_OBJECT;
begin
repid := find_report_object('TESTRPT');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, CACHE);
/* This should let you preview the report on your screen */
rp2rro.rp2rro_run_product(REPORTS,REP_NAME,SYNCHRONOUS,RUNTIME,FILESYSTEM,NULL,NULL);
destroy_parameter_list( param_id ) ;
end ;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
