PL/SQL functions : not possible to call via Oracle ODBC Driver

From: Adrian Hodson <adrian.hodson_at_wanadoo.fr>
Date: 1998/02/20
Message-ID: <6cn9ke$php$1_at_peuplier.wanadoo.fr>#1/1


I am able to call PL/SQL procedures from MS Access 97 via MS ODBC Driver for Oracle, but have difficulty calling functions.

SELECT ABS(<Numeric_field>) FROM <Table>                   -- IS OK

SELECT ROUND(<Numeric_field>) FROM <Table>           -- IS NOT OK

SELECT plsql_function(<Numeric_field>) FROM <Table>       -- IS NOT OK


Thanks

Adrian Hodson
Bouligny (former "Texas of France") Received on Fri Feb 20 1998 - 00:00:00 CET

Original text of this message