Hi newbie01, On Monday 19 Apr 2010 12:21:45 newbie01 perl wrote: > Hi all, > > I need to convert a lot of UNIX scripts into Perl. Most of them uses the > UNIX's EOF/EOL functionality. These scripts are mostly used to connect to > Oracle databases. At the moment, installing a DBI is not an option.
See: http://www.shadowcat.co.uk/blog/matt-s-trout/but-i-cant-use-cpan/ > The > scripts will be running locally on the servers so technically it should be > able to connect to the database without using a password. > > Example of a very simple test script is as below. If I run the script on > UNIX, it is all good. But on Windows, it gives the error "<< was unexpected > at this time." Can anyone please advise what I needed to change to get both > running for UNIX and Windows? > > Thanks in advance. > > Sample test code below: > > > sub test_01() > { > print "+-------------------------------------+ \n"; > print "Running :: sub test-01 !!! \n"; > print "+-------------------------------------+ \n"; > > print << `EOL`; > sqlplus -S "/as sysdba" <<SQLEND The <<SQLEND here document is parsed and executed by the UNIX shell, and it is not supported on the Win32 excuse for a shell called CMD.EXE. You can try doing it using cygwin or something if that is an option or alternatively writing these command to a file first and then loading it using "< input-file.txt" which is more portable. Regards, Shlomi Fish -- ----------------------------------------------------------------- Shlomi Fish http://www.shlomifish.org/ "The Human Hacking Field Guide" - http://shlom.in/hhfg Deletionists delete Wikipedia articles that they consider lame. Chuck Norris deletes deletionists whom he considers lame. Please reply to list if it's a mailing list post - http://shlom.in/reply . -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
