RE: :Oracle and DBMS_STATS

[Markham, Richard]

try $dbh1->do("BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(ownname =>
'USER',cascade => TRUE,options => 'GATHER'); END;);

-----Original Message-----
From: Steve Main [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 12, 2003 1:49 PM
To: [EMAIL PROTECTED]
Subject: DBD::Oracle and DBMS_STATS




Hello list,

I'm having trouble finding a way to run DBMS_STATS from perl.....

$sth1 = $dbh1->prepare("DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'USER', 
                                                       cascade => TRUE,
                                                       options =>
'GATHER')");

$sth1->execute();

Is there another way to run package/procdures ?

thanks for your time

Steve