Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Crystal Reports and Stored procedure

Re: Crystal Reports and Stored procedure

From: Turkbear <john.greco_at_dot.state.mn.us>
Date: Fri, 05 Sep 2003 08:44:25 -0500
Message-ID: <5m4hlvc3upjc8gu669uqodmmao607ol2rb@4ax.com>


"Paul Sun" <phsun_at_lucent.com> wrote:

>In the VB application, the program uses VB crystal report control to call a
>Crystal Report Template.
>The Crystal report template called a Oracle stored procedure. It requires 3
>parameters, (IN OUT) a cursor,(OUT) a date,(OUT) a char.
>In VB program, user can dynamically assigns parameters to the crystal report
>which used the Oracle stored procedure.
>But, when the Crystal report is called, it returns 20998 error (no error
>description) to VB.
>
>Could you show me a direction or solution?
>
>Thanks.
>
>Paul
>
>

In general Crystal can only 'see' the results from a SP when the SP returns a cursor ( and nothing else), but, to test this, create a stand-alone Report using the same Template and run it in Client-Server mode..The error message may be clearer then..   Received on Fri Sep 05 2003 - 08:44:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US