Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Packages

Status
Not open for further replies.

IanWaterman

Programmer
Jun 26, 2002
3,511
GB
I am using CR10 with Oracle 9

I would like to report off an Oracle package. In the database expert I can see the packages under Qualifiers but I can not load them onto the report. I can open the package and see the individual Stored Procedures and I can select these into the report but as with all stored procedures I can not join them together.

Is there any way of using the data from a package in a report.

Thank you

Ian

 
Hi,
Packages do not return data, they just help manage the Procs and Functions, etc. within them...

Try using the various SPs as datasources for subreports, instead of trying to link them in one main report..



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top