SQL & PL/SQL

hi everbody

I'm creating a Form and I want this Form to have a text entry.

actually now after created the form I can't insert the Text that I entered in Description and Solution it gave me an error that saying
FRM-40508: oracle error: unable to insert record.
in the second table I can insert Text but it doesn't save the Text I entered in one record so I found each 2 rows I entered in Description in one record which is not what I want. because I want the whole text should be in one record.

create table alternativemed (
disease_id number(10) PRIMARY KEY,
disease_name varchar2(80),
description raw(2000),
solution long
);

and also I created another table for testing

create table alternativemed1 (
disease_id number(10) PRIMARY KEY,
disease_name varchar2(80),
description varchar2(2000),
solution varchar2(2000)
);

So is there any problem in the datatype that I'm using either RAW or LONG And Varchar2 or it should be in something else. and what kind of property can allowed me to write like a Text because I don't want the Information that I'm entering to be retrieved in one single line.

Thanks a lot

Edited by: lastterminal@gmail.com on Jun 7, 2009 6:10 PM