On Fri, 19 Apr 2002 14:50:08 +0900 Ryoji Watahiki <[EMAIL PROTECTED]> wrote:

> In fact. cording is  $dbh->do("$enb_trg")
> 
> I  tried it  in your way before,but the result is same.
> $dbh->do("$enb_trg") -->NG
> $dbh->do($enb_trg)    -->NG

What did you see (or not see) that caused you to decide that either of
these did not work?

> I  tried  below  this(debug mode) ,but print sentence of debug mode
> display 
> until finish1.
> So,  I think the part of  "$dbh->do($enb_trg)" is incorrect or illegal..
> 
> ===================================================================
>   print "Content-Type: text/html\n\n";
>   $dbh = DBI->connect("dbi:Oracle:$dbname",$user,$passwd)
>                             || &die2("Unable to connect $DBI::errstr");
>   print "finish1";
>   $enb_trg ="ALTER TRIGGER  test_trg  enable";

# Error checking is vital to reliable performance. 
# Try this instead
$dbh -> do( $enb_trg ) or die2( "ALTER TRIGGER failed, $DBI::errstr" );

>   $dbh->do($enb_trg) ;
>   print "finish2";
> ===================================================================


--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.


Reply via email to