Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Unable to Create Data Sets in Non Standard SQL (Anonymous)

Jacob-Oracle
Rank 1 - Community Starter
Summary
Unable to Create Data Sets in Non Standard SQL (Anonymous)
Content
Hi,
1)
Created sample data set using Non Standard SQL.
DECLARE
type refcursor is REF CURSOR;
:xdo_cursor refcursor;
BEGIN
OPEN :xdo_cursor
FOR SELECT * from hr_operating_units;
COMMIT;
END;
2)
Created "xdo_cursor" as a parameter.
3)
I am geting the below error.
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: Missing IN or OUT parameter at index:: 1
Any help is much appreciated.
0