Re^3: EOF problem with sqlplus on Windows

JavaFan, It still does not work. But we tried with a colleague to execute sqlplus with the "<<" on the server itself. The same error occurs : "<< etait inattendu" ( << was unexpected ) We need to search the way to execute multiple sqlplus commands at the windows prompt now. Thanks Jean-michel

Comment on Re^3: EOF problem with sqlplus on Windows

Replies are listed 'Best First'.
Re^4: EOF problem with sqlplus on Windows by JavaFan (Canon) on Mar 23, 2012 at 15:44 UTC
I never claimed it would work. In fact, it seems you have a Windows shell problem. I've never worked on Windows, don't care about the platform, and never will work on Windows. I don't have any suggestions how to solve your problem (well, except upgrading to something useful, like VMS or a Unix flavour or even Linux) What I did point out was that the "problem" isn't caused by qx not able to deal with newlines. It can. If the shell you're using cannot deal with multi-line statements, get a better shell. If your shell does not understand here documents, don't send a here document to it. This is not a Perl problem.	[reply]
Re^4: EOF problem with sqlplus on Windows by choroba (Cardinal) on Mar 23, 2012 at 15:26 UTC
What shell does your server run?	[reply]
Re^4: EOF problem with sqlplus on Windows by theophanie77 (Novice) on Mar 23, 2012 at 15:48 UTC
YES !!! ( thanks to http://damir-vadas.blogspot.fr/2010/11/how-to-redirect-sqlplus-result-in.html ) We thus made it this way : `$my_sql="select sysdate from dual"; my $request="echo $my_sql\\|sqlplus system/password"; $result=qx($request);` [download] Thanks for your help Jean-michel	[reply] [d/l]