in reply to Re: How to read Oracle LONG datatype columns usig PERL?
in thread How to read Oracle LONG datatype columns usig PERL?

thankd for the reply. but does the ora_lob aspect that you mentioned hold good for LONG datatype also?
  • Comment on Re^2: How to read Oracle LONG datatype columns usig PERL?

Replies are listed 'Best First'.
Re^3: How to read Oracle LONG datatype columns usig PERL?
by mje (Curate) on Jan 27, 2010 at 17:19 UTC

    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.

      "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.