SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBD::Oracle::db prepare failed: error

528366Sep 11 2006 — edited Oct 8 2006

Hi, 

I am running a perl script which accesses the Oracle 10g Express. And Im getting this error.

 
DBD::Oracle::db prepare failed: ERROR Database disconnected
 
Here's my code snippet.
 
<tt>
my $query = "SELECT emp_single
FROM customer WHERE school = ? "; 

my $sth = $dbh->prepare($query); 
$sth->execute($school); 
</tt>
 
The database instance is created properly.
 
Can anybody help me with this??
 
Thanks.
 
Thilani

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2006

Added on Sep 11 2006

1 comment

728 views