Use placeholders to avoid the whole problem. Read all about them in the
fine manual (perldoc DBI).
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "gopinath r" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 17, 2001 08:08
Subject: Oracle Insert Problem-Urgent
> my problem is to insert a varchar2 datatype which
> contains single quote(') into Oracle table from Perl.
>
> i am using ActivePerl for windows...how to handle this
> problem.
>
> eg. inset into Tname values('Gopi's','20');
