Hi,
I am new to this list and am looking for some help. I have tried finding my
problem with perldoc DBI and the FAQ, but without luck... 8(
I am trying to execute the following statement:
$query = $dbhandle->prepare("select FAXID from GMX.FAX_DIR where
PROCESSLEVEL=2 and (sysdate - LASTCHANGE)<$T_MAX_OPEN ");
The error I get is:
Can't call method "prepare" on an undefined value at ./myprog.pl line 144.
However executing the same thing with sqlplus is no problem:
SQL> select FAXID from GMX.FAX_DIR where PROCESSLEVEL=2 and (sysdate -
LASTCHANGE) > 12;
no rows selected
SQL>
Also I checked $T_MAX_OPEN and it contains a value...
Thanks,
Joachim
