Yes. However, if you just have to have more than 1, you can create a supplemental table with just 2 columns -- keyid [which is really just a FK reference to the parent table] and a LONG data type column. There would be a 1-to-1 relationship between the 2 tables.
While I do not know what your needs are, but I can say that I have never had a need for multiple memo fields in any 1 table.
>Hi Mark,
>
>I'll check out the article.
>
>Isn't the LONG datatype limited to one instance per table in Oracle?
>
>Guy
>
>
>>I use the LONG data type for memo fields. So far, I have had no problems with this data type for memo fields.
>>
>>I will say this, after I am finished with this project, I plan to write up some documentation about what I did, including scripts, sample code, etc. I do have 1 doc in the Articles section here on the UT. Click the ARTICLES button, then click on the Client/Server category.
>>
Mark McCasland
Midlothian, TX USA