Hi everybody,

 

       I am a new user of crystal reports and at first i faced a problem before beginning reporting.

 

       I write a stored procedure which I think that there is no mistake with it but when it comes to add source from  Database Expert window , I find my sp under my schema but cannot add it. The error is:

 

        Query Engine Error:' ADO Error Code 0x

        Source :OraOLEDB

        Description : ORA-06550: line 1 column 7:

        PLS-00306 : wrong number or types or arguments in call to 'guzintestsp_ekipman'

        ORA-06550 : line 1 , column 7:

        PL/SQL: Statement ignored

        Native error:'

 

 

         my stored procedure is:

 

       

CREATE OR REPLACE PROCEDURE wmstest.guzintestsp_ekipman (

p_result OUT sys_refcursor

)

AS

BEGIN

OPEN p_result FOR

SELECT DISTINCT dp.ekipmankod, dp.tanimi ekipman,

mst.tanimi ekiptiptanim

FROM tbldp_ekipman dp INNER JOIN tblmst_ekipmantip mst

ON dp.ekiptipid = mst.ekiptipid

;

END;

/

 

I need a help about this problem because i couldn't find antwhere on web about this. I think there is a mistake about provider or something about system because i cannot add any stored procedures in any schmas from my pc.

Any help appreciated.!!!