Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Crystal Reports and Stored procedure
Paul Sun 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
>
>
>
Results must be an in the form of a REF CURSOR as an IN OUT parameter.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Sep 05 2003 - 23:07:40 CDT