Help: Oracle -> ODBC -> MSWord95

I have a WordBasic macro which gets data from an Oracle database using an SQL query.
The macro calls various functions in a library file WBODBC.WLL (an unsupported Microsoft product which came from a CD-ROM with the MS Press book 'Developing Applications with MS Office 95').

I want to change my (working) macro so that it calls an Oracle stored function thus:
  select package_name.function_name(param1, param2)    from table_name
   where ...(etc)
instead of using WordBasic to perform some standard 'business layer' operations.
The function has been tested and is available to the current user!

I get a 0 result from the SQLExecQuery call when I change it to use the stored function, followed by -1 row- and column-counts. This behaviour, i.e. failure to recognize a function call, is similar to that which occurs when running an Oracle Reports 2.5 program with a function call in a SELECT on the client side, which uses PL/SQL V1, and which can be cured by moving the SELECT to a stored procedure on the server side, which uses PL/SQL V2.

Does anyone out there know whether my WordBasic problem is related to this, and/or whether there is a newer version of WBODBC.WLL available (mine is dated 29-Aug-1995), or some other way around the problem?

/ David

david (dot) rose (at) draco (dot) se (dot) astra (dot) com Received on Sat Feb 28 1998 - 00:00:00 CST