Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use the EXEC_SQL package to base a report on two data sources simultaneously?

April 26, 2017base Data package report simultaneously sources

0

Posted

Can I use the EXEC_SQL package to base a report on two data sources simultaneously?

1 Answer

0

Posted

The EXEC_SQL package uses PL/SQL to programmatically fetch a single row of data at a time. In Oracle Reports, you may have an unlimited number of queries based on a single Oracle Database connection. You may also have an unlimited number of PL/SQL connections for a single data fetch. The EXEC_SQL package should not be used for more than one data source in a report. It could be used to populate parameters or use the data within a PL/SQL trigger, such as a Before Report trigger. In order to use different databases in the same report, you can use the JDBC data source, which allows you to create a different connection for every JDBC query in your data model.