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: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 05 Sep 2003 21:07:40 -0700
Message-ID: <1062821238.337580@yasure>


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

Original text of this message

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