How can I setup a function to return a ref cursor ... - Oracle …
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,
How to call a stored procedure in BI Publisher Data model — Oracle
Nov 15, 2017 · 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 …
Anonymous Block in BIP — oracle-mosc
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 …
PL/SQL (MOSC) - Oracle Community
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 …
OTBI reporting errors after 25B release - Oracle Community
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
Error ORA-22902: CURSOR expression not allowed ... - Oracle …
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:
How do I use a PIVOT query with a cursor in PL/SQL? — oracle-mosc
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.
R12 Credit Management: Case folder: user-defined data points
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 …
Autonomous Database - Oracle Community
Jan 22, 2025 · #config_dir="C:\oracle\Wallet_mani.zip", # Path to your wallet directory wallet_location="C:\oracle\Wallet_mani", # Path to your wallet wallet_password="XXXX666" # …
display data from the second data source (ref cursor ... - Oracle …
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).