Forum Stats

  • 3,769,715 Users
  • 2,253,014 Discussions
  • 7,875,158 Comments

Discussions

How to create stored procedure that can be read through Hyperion intelligen

hello everyone out there. I need some help I create a select stored procedure and would like to run it through Hyperion intelligence with some input parameters. The procedure is not working. it is throwing an error when I execute it through Hyperion. Also how do I put multiple values like an array sort of things in a where clause like this where name in('test', 'test1). I place the stored procedure below any help will be greatly appreciated.

CREATE OR REPLACE PROCEDURE emp_by_dept (
p_deptno ert_dept_t.dept%TYPE
)
IS
emp_refcur SYS_REFCURSOR;
v_dept ert_dept_t.dept%TYPE;
v_deptname ert_dept_t.deptname%TYPE;
BEGIN
OPEN emp_refcur FOR SELECT dept, deptname FROM ert.ert_dept_t WHERE dept = p_deptno;
DBMS_OUTPUT.PUT_LINE('dept deptname');
DBMS_OUTPUT.PUT_LINE('----- -------');
LOOP
FETCH emp_refcur INTO v_dept, v_deptname;
EXIT WHEN emp_refcur%NOTFOUND;

END LOOP;
CLOSE emp_refcur;
END;
This discussion has been closed.