On Tue, 15 Jan 2002 15:16:10 +0100, Mimmus wrote:
>is it possible to execute 'CREATE INDEX' statement with DBD-Oracle?
>I tried with:
>
>$sth = $dbh->prepare( qq{
> CREATE INDEX ID_BIL_VCEE_IDX ON BEATRICE.VOCI_CEE (ID_BILANCIO)
>unrecoverable
>}) || die "Can't prepare statement: $DBI::errstr";
>$sth->execute || die "Can't execute statement: $DBI::errstr\n";
Try "do" instead.
$dbh->do(qq{CREATE INDEX ID_BIL_VCEE_IDX ON BEATRICE.VOCI_CEE
(ID_BILANCIO) unrecoverable});
HTH,
Bart.
