immediate help for a newbie to browse stored procedure for a report !! :(

[cuttie]

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 in Visual Studio 2005 , 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.!!!

 

[KenHigg]

I don't mean to be brash but saying you need 'immediate help' sounds a tiny bit impertinent...

A better approach (imho) would be to include something that indicates you are willing to wait for any help you can get -

 

[cuttie]

I try to do my work and i couldn't do at the first time is the way of asking my question so important to you?

If you dont care about my problem pls dont bother to write here.

What kind of help center is this?

 

[MSAccessRookie]

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 in Visual Studio 2005 , 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.!!!

I do not believe that this Select Statement is in the proper Access Format:

• Aliases are not explicitly defined (This might work anyway).
• One variable is improperly defined (This will cause an error).

SELECT DISTINCT dp.ekipmankod, 
    dp.tanimi ekipman, 
    mst.[COLOR=red][B][tanimi ekiptiptanim][/B][/COLOR]
FROM tbldp_ekipman [COLOR=darkorange][B]As[/B] [/COLOR]dp 
    INNER JOIN tblmst_ekipmantip [COLOR=darkorange][B]As [/B][/COLOR]mst
        ON dp.ekiptipid = mst.ekiptipid

 

[cuttie]

Thank you for your advise but i tried but unfortunately it is not the solution.

I Think the provider problem but what?

 

[MSAccessRookie]

I will try again.

I noticed that your application has a connection to an ORACLE database, which means that the stored procedure must be in ORACLE PL-SQL Format, not MS-SQL Format. The error refers to the Procedure call, so I limited my search to that area.

CREATE OR REPLACE PROCEDURE [B]wmstest.guzintestsp_ekipman[/B] ([B]p_result OUT sys_refcursor[/B])

ORACLE does not think the procedure wmstest.guzintestsp_ekipman is defined properly compared to its actual usage.

It has been a long time since I have written in PL-SQL, but the prodedure definition does not look correct. I wish I could be of better assistance

 

[Kempes]

The PL/SQL statement should be something like

SELECT DISTINCT dp.ekipmankod, dp.tanimi ekipman, mst.tanimi ekiptiptanim
FROM tbldp_ekipman dp,
tblmst_ekipmantip mst
WHERE dp.ekiptipid = mst.ekiptipid

or

SELECT dp.ekipmankod, dp.tanimi ekipman, mst.tanimi ekiptiptanim
FROM tbldp_ekipman dp,
tblmst_ekipmantip mst
WHERE dp.ekiptipid = mst.ekiptipid
GROUP BY dp.ekipmankod , dp.tanimi ekipman, mst.tanimi ekiptiptanim

Hope this is of help to you