Oracle in Microsoft SSRS
652374Jun 1 2010 — edited Jun 1 2010I am trying to create few report in Mircosoft SQL Server Reporting Services where DB is Oracle.
I am writing all queries in Oracle and it is beign executed in Oracle.
I am trying to use below Stored Procedure which i have written for a report. But when i am executing it in Oracle itself it is giving me error. It is getting complie very well...
Please help me out to find out the error.
The error message is
"encountred symbol TEST_RPT_PROC when expecting one of the following := .( @ %"
Stored Procedure is
CREATE OR REPLACE PROCEDURE TEST_RPT_PROC IS
cursor qresult is SELECT sql_id_cnt,username FROM em_monitor.sql_ovr30_sec_curr_ite order by sql_id_cnt;
aresult qresult%ROWTYPE;
BEGIN
OPEN qresult;
LOOP
FETCH qresult INTO aresult;
EXIT WHEN QRESULT%NOTFOUND;
DBMS_OUTPUT.put_line(aresult.sql_id_cnt);
END LOOP;
CLOSE QRESULT;
END;