no display error

<br>
<b>this is my program:</b><br><br>
use DBI;<br>
use Error qw(:try);<br>
#-<br>
my $username = "SCOTT";<br>
my $password = "TIGER";<br>
my $hostname = "192.168.0.14";<br>
my $dbh;<br>
my $sth;<br>
my $sql;<br>
#-<br>
    try{<br>
&nbsp;&nbsp;&nbsp;        $dbh =
DBI-&gt;connect('dbi:Oracle:host='.$hostname.';sid=ORCL;
port=1521;server=dedicated',
                            $username,$password,{RaiseError
=&gt; 1,AutoCommit =&gt; 0});<br>
&nbsp;&nbsp;&nbsp;        try{<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           $sql =qq{ INSERT INTO PROVAXX VALUES('RICCARDO',
1) };<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           $sth=$dbh-&gt;prepare( $sql );<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           $sth-&gt;execute;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           print "n * insert ok n";         
<br>
&nbsp;&nbsp;&nbsp;        }otherwise{<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           $dbh-&gt;rollback(); <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
           print "n * Error insert n";<br>
&nbsp;&nbsp;&nbsp;        };<br>
&nbsp;&nbsp;&nbsp;       
$dbh-&gt;disconnect;<br>
}otherwise{<br>
&nbsp;&nbsp;&nbsp;        print "n * Error
connect n";<br>
};<br>
--------------------------- <b>Result is:</b>
<br>
DBD::Oracle::st execute failed: ORA-00942: table or view
does not exist (DBD ERROR: error possibly near
&lt;*&gt; indicator at char 13 in ' INSERT INTO
&lt;*&gt;PROVAXX VALUES('RICCARDO', 1) ') [for
Statement " INSERT INTO PROVAXX VALUES('RICCARDO', 1)
"] at d:perljobpgm_3.pl line 17.<br>
<br>
* Error insert<br>
---------------------------
<b>I want this result:</b><br>
<br>
* Error insert<br>
---------------------------



To write a respons, access
http://ww
w.cpanforum.com/response_form/3606

To see the full thread, access
http://www.cpan
forum.com/threads/3603

--
You are getting this messages from www.cpanforum.com
To change your subscription information visit http://www.cpanforum.
com/mypan/