Re: Using Crystal Reports to call an Oracle package?

Crystal Reports can only use Oracle Stored Procedures,not Functions, and the SP must return a REF CURSOR ( similar to a recordset )...

hlngus_at_hotmail.com (Yvonne G) wrote:

>I'm getting an "Error in compling SQL Expression: syntax error found here",
>when calling an Oracle package using Crystal Reports, which I believe is
>just Crystal saying it can't read the package.
>
>The function basically converts a float number into a text string
> that indicates which of 30 flags are being set.
>It runs fine from within TOAD.
>
>I'm using Crystal 8.0.1.1 and Oracle 8.01.06 and ODBC (pdsodbc.dll) .
>
>Code is as follows:
>
>SELECT
> classname class,rpad(description, 43, ' ') description,
> SFC.RADIX.TO_BIN(ABS(CLASS.FLAGDISPLAY))
>FROM class
>
>snippet of package:
>CREATE OR REPLACE PACKAGE BODY radix
>IS
>
> FUNCTION to_bin( p_dec IN NUMBER ) RETURN VARCHAR2
> IS
> BEGIN
> RETURN to_base( p_dec, 2 );
> END to_bin;
>END radix;
>/
>Thanks for any input.
Received on Thu Jul 24 2003 - 10:23:32 CDT