On Tue, 22 Oct 2002 16:41:48 -0400 Steve Sapovits <[EMAIL PROTECTED]> wrote:
> This does it if I substitute the 'XXX' values with our access params.
>
> #!/usr/local/bin/perl
>
> use strict;
> use DBI;
>
> my $dbh = DBI->connect('DBI:Oracle:XXX', 'XXX', 'XXX', {RaiseError =>
> 1});
>
> $dbh->do("CREATE TABLE foo (col_1 VARCHAR2(10), col_2 NUMBER)");
> $dbh->do("INSERT INTO foo VALUES ('foo', 1)");
>
> my $sth =
> $dbh->prepare("CREATE TABLE foo2 AS SELECT * FROM foo WHERE col_2 =
> ?");
>
> $sth->execute(1);
Try adding DBI->trace(4) to see what DBI thinks is happening.
--
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.
