REPOST: Re: LONG/LONG RAW Limitation
Date: Mon, 31 Dec 2001 08:57:12 +0530
Message-ID: <2$--$$-$-%-_$%_$$$_at_news.noc.cabal.int>
Hi
According to the microsoft documentation LONG RAW data when used as parameter of stored procedure will get truncated by 32K. Is this a limitation of OLE DB or PL/SQL? Also does this limitation exist in OraOLEDB? Can I use LOB parameter with Oracle 8.0 database or do i need 8.1 or higher?
Nirmal
"Noodles" <noodles_at_aol.com> wrote in message
news:20011227202514.12544.00002682_at_mb-fj.aol.com...
> I had the same problem a while back and the solution was to get rid of the
> PL/SQL and use a PRO*C program with a large enough memory buffer to
handle the
> long raw column. (Technical support was from T. Kyte via this newsgroup)
>
> If you want, let me know and I'll can send you the PRO*C source as an
example.
>
> Cliff
> clifford_buetikofer_at_<never_no_spam>merck.com
>
>
- WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!news.ruhr-uni-bochum.de!news-koe1.dfn.de!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!zur.uu.net!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: "Nirmal TS" <nirmal.ts_at_in.bosch.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools Subject: cmsg cancel <a0olv0$ahd$1_at_ns2.fe.internet.bosch.com> Control: cancel <a0olv0$ahd$1_at_ns2.fe.internet.bosch.com> Date: Wed, 2 Jan 2002 04:16:11 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.a0olv0$ahd$1_at_ns2.fe.internet.bosch.com> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009948088 29203 166.102.15.34 (2 Jan 2002 05:08:08 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 05:08:08 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40286976
autocancel Received on Mon Dec 31 2001 - 04:27:12 CET