You can simply select an oracle 'long' in the same way as a char type.
create table longtest (longfield long);
insert into longtest values ('aaa');
insert into longtest values ('bbb');
$sth=$dbh->prepare('select * from longtest');
$sth->execute;
while (my @row=$sth->fetchrow_array){
print $row[0] if $row[0] =~ /aaa/;
}
-----Original Message-----
From: praveen [mailto:[EMAIL PROTECTED]
Sent: 06 January 2004 21:41
To: [EMAIL PROTECTED]
Subject: handling oracle long data types
hi-
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.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
__________________________
This email and any files transmitted with it are confidential and intended solely for
the use of the individual or entity to whom they are addressed. The contents are
confidential and may be privileged.
Any views or opinions expressed are those of the sender and may not reflect the views
or opinions of the company and the company accepts no liability in respect thereof.
If you have received this email in error please notify [EMAIL PROTECTED] immediately.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
