Re^3: How to read Oracle LONG datatype columns usig PERL?

DBD::Oracle says:

There are also legacy LONG types (LONG, LONG RAW, VARCHAR2) which are presently deprecated by Oracle but are still in use. These LONG types do not utilize a 'LOB Locator' and also are more limited in functionality than CLOB or BLOB fields.

I misread your question and assumed you meant lobs and not the old deprecated long type. I don't use longs so I cannot say but the comment above would suggest there is not a lob locator.

I guess you need to read this.

Comment on Re^3: How to read Oracle LONG datatype columns usig PERL?

Replies are listed 'Best First'.
Re^4: How to read Oracle LONG datatype columns usig PERL? by Mr. Muskrat (Canon) on Jan 27, 2010 at 19:59 UTC
"There are also legacy LONG types (LONG, LONG RAW, VARCHAR2)" I think that this is a mistake in the DBD::Oracle docs (unless I am missing something in the Oracle documentation). VARCHAR is deprecated but VARCHAR2 is not.	[reply]