Re: Passing large char buffers from a C extended procedure

mukesh bhakta wrote:
> Hi guys,
>
> I have a C function which returns large string buffers (> 4000 bytes)
> to the calling application. I understand VARCHAR2 has a 4000 character
> limit under Oracle and cannot be used for passing.
>
> I read about CLOB being an alternative but cannot find any code samples
> to pass it from C and declare it in a stored proc.
>
> Can someone please help me with this?
>
> Regards
>
> MB
>

Mukesh,

varchar2 limit in PL/SQL is 32k. You can pass a C buffer to a stored procedure as varchar2 datatype. Of course, you cannot insert it into a table, because the varchar2 column limit for a table is 4k.

I presume you are using OCI. I suggest you take a look at the OCI Lob API's too.

Rgds.
Amogh Received on Tue Apr 11 2006 - 00:41:20 CDT