Jan 15, 2015 · Hi there, I am trying to create a database function/procedure that returns a ref cursor that will reference an existing cursor. For example,

Thank you very much for the detailed information! Can you please give me the syntax/example how the parameters are passed in data set. I'm actually creating the report using package first time.. all your …

Jul 22, 2014 · The documentation doesn't offer many details or a simple working example. What I've tried is this: DECLARE type refcursor is REF CURSOR; xdo_cursor refcursor; BEGIN OPEN …

Mar 8, 2012 · In my simple example I have a table with the columns user_name and Is_admin.The Is_admin column only has two distinct values: 0 and 1.

May 19, 2025 · Reporting and Analytics for ERP OTBI reporting errors after 25B release - Error generating view. Error getting cursor in Generate May 19, 2025 6:54AM 5 comments

Jun 20, 2010 · Hi, I need an Additional data Point (ADP), this ADP will show the Last Credit Application Date. When I create the function, how can I use the customer for me new application and to be able …

Mar 29, 2023 · Hi, I'm running ords 21.4 Starting today, if I execute a query including cursor expression from database actions sql-developer (web), I get an error: ORA-22902:

May 30, 2019 · PL/SQL (MOSC) dbms_sql.fetch_rows gives me "ORA-19011: Character string buffer too small" for XMLYTPE column May 30, 2019 11:44AM edited Jun 4, 2019 10:58AM 6 comments …

Feb 15, 2011 · Use View -> Find All to retrieve all records.' ) poll data from the second source being ref cursor procedure (created a block based on this ref cur just for the data query).

Dec 30, 2019 · For the past 2 months I have been capturing SQL workload using the DBMS_SQLTUNE.CAPTURE_CURSOR_CACHE_SQLSET. This data was used for 11G to 12C …