Have you tried backticking SQL*Plus ? Example (not tested) `sqlplus scott/tiger\@dbservice \@/home/cshao/test/test.plb`;
P.S. my $max_callid = $_; $sql = $sql.$max_callid; is more concisely written as: $sql .= $_; -----Original Message----- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 8:38 PM To: Shao, Chunning; Adam B. Edwards Cc: [EMAIL PROTECTED] Subject: Re: Help: How do you run wrapped sql? On Sun, 14 Jul 2002 22:44:45 -0400 "Shao, Chunning" <[EMAIL PROTECTED]> wrote: > which works fine > > but after I wrap it, > [cshao@beltway ~/test]$ wrap iname=test.sql oname=test.plb > PL/SQL Wrapper: Release 8.1.7.3.0 - Production on Sun Jul 14 22:42:55 2002 > Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. > Processing test.sql to test.plb > > The same script > > my $max_callid_file = "/home/cshao/test/test.plb"; > my $sql; > open MAX_CALLID,$max_callid_file||die "error"; > while (<MAX_CALLID>) > { > my $max_callid = $_; > $sql = $sql.$max_callid; > } > close MAX_CALLID; > $dbh->do($sql); > > I got the following error > > [cshao@beltway ~/test]$ ./test.pl > Can't mix placeholder styles (:1/:foo) at > /usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD/Oracle.pm line 293. > > Is there any way I can run a wrapped sql statement from DBI? Probably not. DBI is not SQL*Plus. Have you tried listing test.plb with cat or less? -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
