ODBC with ORACLE passing long text parameter

From: Pierre-André Briod <pierre-andre.briod_at_mbox.bfs.admin.ch>
Date: 1997/06/03
Message-ID: <3393BADA.10D9@mbox.bfs.admin.ch>#1/1

With Oracle 7.3, ODBC OpenLink Version 1.5 Driver for Oracle, Visual C++ 5.0, we have
been trying to pass texts > 256 characters to and back from a stored procedure.
The only way we have found to do this in the input direction (to the database) is with SQLPutData,

where we bind the text parameters as SQL_DATA_AT_EXEC.
This works, but is unfortunately not supported by RFX.
In the output direction, we have not found a solution. There is no way

to use
SQL_DATA_AT_EXEC with output parameters as far as we can see. We have also tried passing LONGVARCHAR2, but the Open Link driver just truncates the texts without warning when they go over 256 characters. Has anybody else had to deal with this problem??

Thanks!

Pierre-A. Received on Tue Jun 03 1997 - 00:00:00 CDT