Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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)

Question
32
Views
0
Comments
Jacob-Oracle
Jacob-Oracle Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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.