procmail
[Top] [All Lists]

Re: Executing select statement with sqlplus

2007-05-30 06:49:15
On Wednesday, 30 May, 2007 at 15:11:03 +0200, Paul Bijnens wrote:
On 2007-05-30 14:28, Alex Kosach wrote:
Yes, my statement seems to be correct. I got almost the same error
message when I tried to execute this select without providing correct
credentials.
However, everything worked perfectly after I specified user
name/password and the system

When working with dinosaurs like Oracle, you need to set up the
correct environment  (LD_LIBRARY_PATH in this case),  better
do ". oraenv" to get that (among other stuff) correct.
And to be able to ". oraenv" you must be executing in a shell,
so better make that ". oraenv" + sqplus some shell script
executed by procmail.

I thought it was something like that, but not knowing anything about
SQL, sqlplus, Oracle, &c., I didn't want to put my neck on the block.
;-)

BTW  Please do _not_ CC me, I _am_ subscribed to the list and _do_ read
everything posted to it.  That goes for you too Alex!  :-)


Cheers,
       Nick.
-- 
Please do not CC me on replies, I read the list and don't need the dupes.


____________________________________________________________
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>