Pro*C text insertion Question

I was wondering if anyone can solve the problem I have. I am reading text from a file and extracting certain information from each file.

I have declared something to be of type long

e.g text_is long,

Now how can I insert a line of text into this type one line after another until the file has been completely read.

I have tried the following

 exec sql update set text_is = :line

                   where mess_id =:get_id;

all this does is overwrites each existing line in the database column with the line just read and inserted into.

I guess a cursor wont help as I am trying to insert data into a table, not extract it.

I dont really want to create a huge array that will hold each line of text and do one insert at the end.

Is there another way to do it. I have no experience in the data processing data entry field of databases so I guess someone out there knows how to go about these things.

		              Thanks.	
				Matthew Carr