using stored procedure to build crystal report 1

[Michali]

hello all
i am having dificulties tryin to use this stored procedure for building a report:

create or replace procedure rpt_415(
pDateFrom in date,
pDateto in date,
TotalReq in out number,
TotalRecvd in out number)
when i am trying to select it i am getting the next error:memory full.
if i am no using "in out" parameters only "out" i am getting error from the DB that i dont send enoth parameters. and if i dont use this parameters at all i get the error that the procedure does not send back any rowset.

any ideas?
than u
michali

 

[synapsevampire]

Please post Crystal version, database type and version when posting, otherwise (as you can see), you're not giving people much to go on.

There are specific concerns when using SP's with Oracle, and they are version dependent, and type of connectivity dependent:

http://support.crystaldecisions.com/library/kbase/articles/c2001157.asp

Note that if you're using the CR supplied Oracle ODBC driver, enable the Procedure Returns Results in the advanced tab.

If you require further assistance, please flesh out your environment.

-k

 

[Michali]

hello k
i have finally succeded. (considering a week break...)
thank u very very much