Returning multiple ref cursors from Oracle procedure to Java

In our web application we have 18 screens in a module. Our user wants all the data of the 18 screens in one page so that they can print the entire data at once.

So, I wrote an Oracle procedure which fetches the data of all 18 screens (from 20 - 22 tables). This Oracle procedure returns 13 cursors to my Java program.

Performance of the page is good and I am getting the desired result.

However, would returning that many cursors to Java create any problems?

Copyright Notice：Content Author:「venki」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/12487953/returning-multiple-ref-cursors-from-oracle-procedure-to-java

Products recommended by Amazon

More >>>

SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN

HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs

AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler

Timberland Men's 6-Inch Premium Waterproof Boot

More about “Returning multiple ref cursors from Oracle procedure to Java” related questions

Returning multiple ref cursors from Oracle procedure to Java

In our web application we have 18 screens in a module. Our user wants all the data of the 18 screens in one page so that they can print the entire data at once. So, I wrote an Oracle procedure which

Show Detail

Returning multiple ref cursors from Oracle Procedure using DAAB & C#

I want to return data from an Oracle procedure to populate some Label controls. The procedure accepts 26 input parameters (search variable) and returns 3 output cursors. I have been successful ret...

Show Detail

How to call a Stored Procedure to Open Ref Cursors with Different Queries

I have a homework assignment that wants me use a stored procedure with cursors to return queries from multiple tables. The query changes based on an input value that's a number, and the queries can...

Show Detail

How to handle multiple ref cursors in data set ? (Birt Report Design)

My data set (created using oracle procedure) returns "multiple ref cursors" . In this case birt is displaying all output columns together and it is difficult to identify which column belongs to whi...

Show Detail

Returning multiple XML from ref cursor oracle

There is a procedure in the Oracle DB which takes a date range and generates XML file for each day and the return type is ref cursor. When the procedure is called from C# code, I am unable to extra...

Show Detail

Benthic Golden Oracle: Return multiple ref cursors from procedure for viewing

I'm used to running a procedure and returning one cursor for viewing: var recCursos refcursor; exec user.package.procedure(inputValue1, :recCursor); However, this time I need to run a procedure t...

Show Detail

How to execute oracle stored procedure returning multiple cursors using c#

I am using OracleClient with C#. I have a stored procedure returning multiple cursors. I have to associate each cursors to different tables. But when It tried to do this I am getting this error. ORA-

Show Detail

How to return multiple rows from oracle stored procedure from multiple cursors?

I need to have stored procedure where I can run multiple cursors. Loop over each cursor and then do some operation on each row. This way I will have the desired result from these cursors. Resul...

Show Detail

Java JDBC - Oracle11g Sys Ref Cursor Vs pl/sql collections

I would like to ask the experts of what is the recommendation for fetching 3000-5000 records from oracle 11g database from Java application (using JDBC). Our standard is to always invoke a stored

Show Detail

Biztalk unable to read Oracle 18 stored procedure with strongly typed ref cursor

We have Biztalk to read data from a table in Oracle by calling a stored procedure. The stored procedure returns a strongly typed cursor and it was working fine with Oracle 12. Updating to Oracle ...

Show Detail