Hi..
I am new to perl programming. I am right now involved in developing
cgi pages in perl. The backend is oracle. I want to know how to trap SQL
codes returned from oracle and redirect my error messages to the browser.
Right now, in the following piece of code
$sql = <<ENDOFSQL;
INSERT INTO EMP
(empno,empname,sal,deptno)
VALUES (303,'ABCD',8000,20)
ENDOFSQL
my $sth = $dbh->prepare($sql) || die " Error while preparing
statement for insertion";
sth->execute || die "Error while executing SQL stmt";
When my SQL fails to execute for some reason, i do not get any message. i
just get a blank page in my browser. what should i do to get the message to
display in the browser ??
Thanx in advance
Lavanya
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
