Oracle Analytics Cloud and Server

Products Banner

Unable to Create Data Sets in Non Standard SQL (Anonymous)

Question
5
Views
0
Comments

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.