i am converting crystal report to SSRS and the crystal reports uses a procedure
PROCEDURE getNotes(
nId IN note.id%TYPE
,noteCursor OUT sys_refcursor
) IS
BEGIN
OPEN noteCursor FOR
SELECT q.note_id,
q.id,
text,
FROM q_note q
where q.id = nid
END;
crystal report was sending to oracle as
BEGIN "schemaname"."packagename"."GETNOTES"(111, :NOTECURSOR); END ;
i selected stored proc and entered this schemaname.packagename.getnotes in the query tab of the datasource(connecting to oracle) and in the parameter tab i added
parameter name as nid and the value as =Parameters!NID.Value.
The fields tab is not retrieving any fields and when i try to execute the query i get the below error
An error occurred while retrieving the parameters in the query.
ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at line 1
(Microsoft Report Designer)
Can anyone can suggest how to fix this ?