Re: long datatype in Pro*C/C++

Vasan,

There is a working program at this site that selects a Long column into a Varchar [32000] variable.
Release 1.6 of the Pro*C Supplement to the Oracle Precompilers Guide states that the maximum length of a VARCHAR is 65333 bytes. A normal char array apparently has no such limitation, although I haven't tried it. Longs are generally avoided here because of their limitations (can't use SUBSTR, etc.).
Without knowing the exact nature of your problem it's hard to comment further.

Vasan K <vasank_at_lips.net> wrote in article <3467bc09.1318808_at_news.lips.net>...
>
> Hi,
>
> I am trying to use a long datatype column in one of my tables. I have
> successfully inserted into the table using embedded sql in Pro*C. I
> am having trouble reading from the table. I am looking for code
> snippets that do this read of a long column from a table in Oracle 7/8
> databases.
>
> I know I can use OCI/PLSQL to do it, but I am specifically looking to
> doing it with Pro*C. Let me know if this is even possible.
>
> post responses or e-mail (preferable) to vasank_at_lips.net
>
> Thanks in advance.
>
> Vasan.
>
Received on Tue Nov 11 1997 - 00:00:00 CET