Xref: alice comp.databases.oracle.tools:23967
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: klimsamgin <klimsamgin@yahoo.com>
Newsgroups: comp.databases.oracle.tools
Subject: Insert 90MB data file in one cell
Date: Tue, 27 Apr 1999 10:37:31 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 18
Message-ID: <7g441b$e5l$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Tue Apr 27 10:37:31 1999 GMT
X-Http-User-Agent: Mozilla/3.04Gold (Win95; I)
X-Http-Proxy: 1.0 CTER, 1.0 x4.dejanews.com:80 (Squid/1.1.22) for client 195.7.178.226

Hi!

I use LONG RAW columns to store large binary datafiles in ORACLE7
under Solaris 2.5 (for example, 90MB file).
And when I insert this big value in the table's cell
at a heat, my PRO*C program can't allocate
enough memory in the system (90MB buffer with data).
To resolve this trouble, I should insert small
pieces of this file in the cell(for examle, 1000x90KB, 1000 pieces).
But how can I do this? Which command need used?

Of couse, I can use 1000 cells, but what about one cell?

Thanks,
Klim.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own