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: problem to retrieve stocked procedure with Crystal Report

Re: problem to retrieve stocked procedure with Crystal Report

From: Thomas Goirand <tgoirand_at_sqli.com>
Date: 19 Feb 2002 03:19:52 -0800
Message-ID: <436db0bc.0202190319.36bee02d@posting.google.com>


Because i'd like my documents independant from database name. is there any solution with native oracle driver ?

Thanks

Thomas

damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C7198C6.817237B1_at_ci.seattle.wa.us>...
> The Oracle Crystal connection works either way.
>
> But why would you prefer the method that is slowest, least secure, and most
> prone to errors?
>
> Daniel Morgan
>
>
>
>
> Thomas Goirand wrote:
>
> > Hi,
> >
> > With Win NT, Crystal Report 8.0.1, Oracle 8.1.7, MDAC 2.7
> > i'd like my Crystal Report documents use ODBC instead of the native
> > Oracle driver.
> > Conversion is working well with my documents which get some tables or
> > views, but i've got an error with docs retrieving a cursor from stocked
> > procedures:
> >
> > ODBC error :[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line
> > 1, column 32:
> > PLS-00306: wrong number of argument or types of arguments in call to
> > 'STOCKEDPROC'
> > ORA-06550: line 1, column 7:
> > PL/SQL: Statement ignored
> >
> > then: cannot open database
> > and: file integrity error
> >
> > also theses documents are working fine with native oracle driver.
> >
> > is Crystal report able to use ODBC to retrieve oracle stocked-procedures
> > whith cursors ?
> >
> > Thanks for your help
> >
> > Thomas
Received on Tue Feb 19 2002 - 05:19:52 CST

Original text of this message

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