On Mon, Jul 01, 2002 at 01:51:44PM -0400, Jennifer Newberry wrote:
> DBD::Oracle::db prepare failed: ORA-00900: invalid SQL statement (DBD:
> error possibly near <*> indicator at char 1 in '<*>'Select a.prty,
> a.mess, a.cdat, a.suno, a.alrt from alerts a where a.dnst = 2 order by
> a.prty, a.cdat DESC'') at d:\Inetpub\wwwroot\smi\alerts.pl line 107.
> *107 - my $sth = $dbh->prepare('$sql') or die "Error in prepare";
Why have you put single quotes around the variable name in the call to
prepare??
Ronald
