Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Crystal Reports and Stored procedure
"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
![]() |
![]() |