Oracle Analytics Cloud and Server

Unable to Create Data Sets in Non Standard SQL (Anonymous)
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.