package run from sql*plus but gives error when called from crys report

[manush]

Hi,

I have a package which when executed from sql*plus, gives result but when called from crystal report, gives 0ra-01861 literal does not match format string.

The input to the procedure are as below

procedure try( in_region IN VARCHAR2,
in_RTU IN VARCHAR2,
in_start_time IN VARCHAR2,
in_end_time IN VARCHAR2,
in_l_port IN VARCHAR2,
in_channel IN VARCHAR2,
in_period IN VARCHAR2,
o_result IN OUT cursor_type)

where cursor_type is of type ref cursor.

SQL> variable a refcursor
SQL> exec pkg_try.try(null,'drcsolliec1',null,null,null,null,null, :a)
PL/SQL procedure successfully completed
SQL> print a

and it prints the record.

I hope, some one of you would help me.

Manoj

 

[synapsevampire]

Here's the generic whitepaper:

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

Please understand that the version of Crystal and the type of connectivity are critical, which you neglected to share.

Also note that you might mention that you're using Oracle, although it may be obvious to many, not to all.

-k

 

[manush]

Thanks, I got the problem..
It was table privileges problem.