Run a block of sql commands using 'here document'

Hi, I know that using 'Here Documents', we can output multiple lines. But is it possible to run a couple of commands? $s = qx [sqlplus user/[EMAIL PROTECTED] ENDOFSQL select 2 from DUAL; exit ENDOFSQL]; Any ideas on how to make the above code work?? (I do not want to install DBI module and then

Re: Run a block of sql commands using 'here document'

Hi, I know that using 'Here Documents', we can output multiple lines. But is it possible to run a couple of commands? $s = qx [sqlplus user/[EMAIL PROTECTED] ENDOFSQL select 2 from DUAL; exit ENDOFSQL]; what do you think about that: open(DBI, | sqlplus user/[EMAIL PROTECTED]); then

Re: Run a block of sql commands using 'here document'

On 6/8/07, Martin Barth [EMAIL PROTECTED] wrote: Hi, I know that using 'Here Documents', we can output multiple lines. But is it possible to run a couple of commands? $s = qx [sqlplus user/[EMAIL PROTECTED] ENDOFSQL select 2 from DUAL; exit ENDOFSQL]; what do you think about that:

RE: Run a block of sql commands using 'here document'

Cool...This worked!!! Thanks a zillion for the response!! Thanks Regards, Lakshmi 952-833-1220 -Original Message- From: Adriano Ferreira [mailto:[EMAIL PROTECTED] Sent: Friday, June 08, 2007 11:56 AM To: beginners@perl.org Subject: Re: Run a block of sql commands using 'here document