Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle in Microsoft SSRS

652374Jun 1 2010 — edited Jun 1 2010
I 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2010
Added on Jun 1 2010
1 comment
1,025 views