procmail
[Top] [All Lists]

Executing select statement with sqlplus

2007-05-29 13:51:07
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

<Prev in Thread] Current Thread [Next in Thread>