Cursor Reference

From: Jayaraj (jayarajo_at_gmail.com)
Date: 10/28/04 

Date: 28 Oct 2004 00:14:26 -0700

Helloo

Is there any restriction cursor reference in DBI/DBD for Oracle?
I am passing a cursor reference from my perl module to a stored
procedure.
Inside the stored procedure, the cursor is created like this

open r_cursor for
 select col1
 from table1
 where <condition>

Here col1 is of type LONG
But the cursor returned in the perl module is empty.

But if I change the type of col1 to VARCHAR2(4000) it is working fine.
My issue in not using VARCHAR2 is the data in col1 might contain
values which will exceed 4000 bytes in length.

Warm Regards
Jay