We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Question
20
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!