Using Crystal Reports to call an Oracle package?

From: Yvonne G <hlngus_at_hotmail.com>
Date: 23 Jul 2003 16:36:50 -0700
Message-ID: <d999b872.0307231536.5019092d@posting.google.com>

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 Wed Jul 23 2003 - 18:36:50 CDT