Xref: alice comp.databases.oracle.server:50580
Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!ix.netcom.com!news
From: shmulik@ix.netcom.com (Shmuel Cohen)
Newsgroups: comp.databases.oracle.server
Subject: LOB (8i) insertion help
Date: Sat, 22 May 1999 12:44:47 GMT
Organization: Netcom
Lines: 21
Message-ID: <3746a6b3.46799203@nntp.ix.netcom.com>
X-NETCOM-Date: Sat May 22  5:46:32 AM PDT 1999
X-Newsreader: Forte Free Agent 1.11/32.235

Can someone show me a sample bit of Sql and pl/sql code to INSERT NEW
LOB records into a database?  All the samples show how to get stuff
out, but not put it in (records > 32K).

For example, if I have a database table defined as:

	create table test (
		MyLOB	CLOB
	);

Let's say I want to insert a piece of text that is 50,000 chars in
length, how do I insert this?  How do you initialize (or do you need
to) the lob instance and insert large files?  Everything works great
as varchar2s of less than 4k bytes, but I need to add large
(megabyte/gigabit) size text.

create or replace procedure add_text (
    ???
)

Thanks