ORA-06512: at "SYS.DBMS_UTILITY", line 114 Error in SSRS

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  January 29, 2011 at 1:58 pm

  #233576

  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 ?