glenn@ocsmd.ocs.com (Glenn Ford) (07/30/90)
Hi, I am new to the world of Oracle and I am having a heck of a time
with the Documentation when it comes to the LONG Datatype. I have
created a table with the LONG data type (for TEXT data entry), and
would like to know how to INSERT new records in with this form. The
Docs (for 5.1A at least, will be upgrading as soon as we get the
contract :-) ) for LONG give me NO CLUE (at least on the hundreds of
pages I have read!) as to how to enter data of this type. Everytime
I go over 240 characters it thinks its a CHAR type and says too long.
Do I need to use a special quoting or what?
After I figure out how to insert >240 characters into field long, I
would like to know how to use sqlforms with this SAME field. Right now
what I do is LINK records together that contain 78 character fields
and just keep a record for EACH line. I want ONE record that contains
lots of lines of text.
I would appreciate any help, and I thank you greatly in advance.
Glenn Ford
BBS: 301-972-6131
HOME: 301-972-2310
UUCP: ..uunet!ocsmd!{stsim!}glennBron@cup.portal.com (George Bron Faison) (08/05/90)
I hate to be the one to tell you, but you can't get there from here. (SQL*PLUS and SQL*FORMS don't support the LONG data type in any meaningful way. You'd have to use HLI/OCI or Pro*C.) There are some add on products for this kind of thing, but I doubt it'd be worth it on the PC version (but someone else may think otherwise, so...) Sorry! Bron Bron@cup.portal.com Modern Office Systems Technology, Inc. 6006-B Mechanicsville Turnpike Mechanicsville VA 23111 (804) 730-1467