I have joining multiple tables and returning data from a stored procedure using a SYS_REFCURSOR. Now the calling program does not want to use SYS_REFCURSOR. What are the other options to return the data? Data is 200000 records and 11 columns
Oracle Other options than SYS_REFCURSOR
128 Views Asked by Marco At
1
There are 1 best solutions below
Related Questions in ORACLE
- Column displays each count
- MAX and GROUP BY - SQL
- Best Practice for adding columns to a Table in Oracle database
- Updating an Oracle row with value from same row
- Retrieving data from Oracle database
- Ibatis execute update sql on oracle, it is not working and no exceptions
- Building an sql execution plan history
- Implementation of Rank and Dense Rank in MySQL
- how to update the date field for this specific condition using oracle query?
- Oracle stored procedure wrapping compile error with inline comments
- Android: How to connect oracle database using Android Java code?
- SQL Conditional Join on Columns
- Multi value wildcard search in ibatis
- Get count of consecutive days meeting a given criteria
- How to update the metadata of a layer in Oracle imported through FME Workbench?
Related Questions in ORACLE12C
- What is the JSON function in 12c?
- SQL*Loader-704 and ORA-12154
- Result from pipelined function, always will sorted as "written", or not?
- Oracle 12c extended to support varchar2 > 4000 bytes doesn't work for user who is not sysdba
- Link errors during Static linking of OCCI/ OCI programs in Oracle 12c
- Hibernate: one-to-one mapping is not working correctly
- Return the sum of the count of two seperate tables PL/SQL
- How to access JSON property in Oracle 12c JSON column using Hibernate's HQL?
- Oracle "impdp" the 11g dump file to 12c - Unable to create user during import
- How to check Oracle database In-Memory space?
- Convert several commas string into rows
- invisible columns in oracle 12c view
- Oracle 12c datapump error when exporting from 11g database
- Spring jpa, how to generate event on insert?
- how to schedule a job on Oracle SQL developer to execute shell command "Java -Jar /Home/JavaFile.jar" each one minute?
Related Questions in SYS-REFCURSOR
- Return the SQL Statement of an Explicit Cursor
- SQL Developer script output truncates sys_refcursor width
- Dynamic sql with bind variable
- Oracle ref cursor fetch hangs if it contains 1 single record
- writing generic pipelined table PL/SQL function with sys_refcursor as in parameter
- Returning a cursor , calling a procedure from other procedure
- Oracle Other options than SYS_REFCURSOR
- Return deleted rows in a cursor in PL/SQL
- passing sys_refcursor from function to sys_refcursor out parameter in procedure
- CUSOR / SYS_REFCUSOR Problems/ BUG on Oracle 19c
- sys_refcursor from procedure not returning data
- Need to get output as select statement, instead of using dbms_output
- Listview DropDownList FindControl without Edit Button
- EF5 how to access SYS_REFCURSOR in Oracle stored procedure
- Unable to get any result set in .NET Core Web API while using Dapper
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?