Re: Help: Oracle -> ODBC -> MSWord95

On Sat, 28 Feb 1998 13:44:34 GMT, david_at_no-spam.thanx.com (David Rose) wrote:

>
>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?
>

Forget all that.
There was an undiscovered error in the stored function, but since no error codes are available to WB it could have been anything!

/David

david (dot) rose (at) draco (dot) se (dot) astra (dot) com Received on Mon Mar 09 1998 - 00:00:00 CST