Re: ODBC with ORACLE passing long text parameter

=?iso-8859-1?Q?Pierre=2DAndr=E9?= Briod
<pierre-andre.briod_at_mbox.bfs.admin.ch> wrote:

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

RFX_Text takes an optional parameter of the maximum length (see Help). This defaults to 256. Changing this may help. Let me know how you get on.

Martin Bell Received on Fri Jun 06 1997 - 00:00:00 CDT