Re: DDE Manager

In article <Jul15.174609.61391_at_acs.ucalgary.ca>

           mortis_at_acs.ucalgary.ca "Jeremy Eric Mortis" writes:

> I am using DDE from Access 2.0 to run some PL/SQL routines on the
> Oracle 7 Server. Does anyone know how to return a value from a
> function or a procedure, other than by temporarily inserting it into a table?
>
> Thanks.
> --
> ----------------------------------------------------------------------------
> Jeremy E. Mortis Internet: mortis_at_acs.ucalgary.ca
> Financial Information Services Phone: (403) 220-4423
> University of Calgary Computing Services Fax: (403) 282-9361
>

The only way to return a values from a PL/SQL procedure or function (as far as I am aware) is to generate a user-defined error number and message.

-- 
Stephen Lappin

+-----------------+
| +-------------+ |  Real Time Engineering Ltd.
| |  Real Time  | |  Capital House
| +-------------+ |  20 Park Circus
| Engineering Ltd |  Glasgow G3 6BE         Tel: +44 (0)41 332 9400
+-----------------+  Scotland U.K.          Fax: +44 (0)41 331 2509