using Perl and Oracle

Hi!
I tried to implement next statement in oracle using PERL:   select f1 from t1 where v1 like '%something%' but I'm using PERL, and something of upper statement is variable. so I implemented upper query in my program following as:

$sql=$dbh->prepare("select f1 from t1 where v1 like '%?%' ");
$sql->execute($variable);

    .....
    next.. $sql->fetchrow ....

the result is:
  execute called with 1 bind variables when 0 are needed at ~~~

in other case... I'v used ? for variable. but in this case, It's not working....

Please.. Help me~

--

 ^_^ BE HAPPY!!!!     from Noh Hui Kyoung - Received on Fri Nov 05 1999 - 06:55:43 CST