Hello
I am trying to execute a simple select from inside a procmail script by
using sqlplus.
:0
* $ ? fgrep -is -f somelist.lst
{
:0 fwh
| formail -I"Subject: SOME SUBJECT ${SUBJ_}"
:0
* CUST_NO ?? .
{ SQLPLUS = `/oracle/..../sqlplus name/password(_at_)server "SELECT
ea.address FROM email_address ea
WHERE ea.cust_num = $CUST_NO and ea.primary_ind = 'Y'"`
:0
* SQLPLUS ?? .
EMAILADDRESS=$SQLPLUS
}
However, the log file shows the following error
Executing "/oracle/...../sqlplus, name/password(_at_)server,SELECT ea.address
FROM email_address ea
WHERE ea.cust_num = XXXXXXXX and ea.primary_ind = 'Y'"
/oracle/........./sqlplus: error while loading shared libraries:
libsqlplus.so: cannot open shared object file: No such file or directory
procmail: Assigning "SQLPLUS="
If understand this message correctly, the script cannot be executed
because I don't provide any user name and password. Does anybody know
how to provide this user name and password to execute this select?
Thanks
____________________________________________________________
procmail mailing list Procmail homepage: http://www.procmail.org/
procmail(_at_)lists(_dot_)RWTH-Aachen(_dot_)DE
http://MailMan.RWTH-Aachen.DE/mailman/listinfo/procmail