i have been using DBI along with DBD::JDBC for working with oracle databases.
i have an issue which i hope someone can help me with.
i need to select text that is stored as "long" in oracle 9i. now i want to compare that with a string that i read from a file. someone suggested that i can use to_lob() in sql and then use an oracle native procedure to compare values.
but i was wondering whether i can convert the value that i get from oracle into a string and be done with a simple =~. is tehre a way?
-- k.p.
