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

ikegami has pointed you in the right direction and it is not difficult. All you really need to decide is if you want lobs retrieved automatically for you (ora_auto_lobs) or if you'd prefer the lob locator and retrieve the lob seperately yourself.

Regarding your comment about not seeing lobs in SQL Navigator I see my clobs with it fine. It shows the first part and if I right click on the row and select "single record view" a box pops up and I can click on the ... in the clob to see it.

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

Replies are listed 'Best First'.
Re^2: How to read Oracle LONG datatype columns usig PERL? by biswanath_c (Beadle) on Jan 27, 2010 at 17:02 UTC
thankd for the reply. but does the ora_lob aspect that you mentioned hold good for LONG datatype also?	[reply]
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.	[reply]
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]