Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsdst02.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!a25fe021!not-for-mail From: Mladen Gogala Subject: Re: Perl - Newbie question User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table) Message-Id: Newsgroups: comp.databases.oracle.server References: <1149627946.026944.302980@h76g2000cwa.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Lines: 17 NNTP-Posting-Host: 70.134.244.207 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr12.news.prodigy.com 1149656345 ST000 70.134.244.207 (Wed, 07 Jun 2006 00:59:05 EDT) NNTP-Posting-Date: Wed, 07 Jun 2006 00:59:05 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: SCSYQN_@OXWMRULYBJKD]_\@VR]^@B@MCPWZKB]MPXHZUYICD^RAQBKZQTZTX\_I[^G_KGFNON[ZOE_AZNVO^\XGGNTCIRPIJH[@RQKBXLRZ@CD^HKANYVW@RLGEZEJN@\_WZJBNZYYKVIOR]T]MNMG_Z[YVWSCH_Q[GPC_A@CARQVXDSDA^M]@DRVUM@RBM Date: Wed, 07 Jun 2006 04:59:05 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268665 On Tue, 06 Jun 2006 14:05:46 -0700, dbaplusplus wrote: > > How do I do same in Perl. I did search on Google but gives the always > found information on DBI interface, but not on what I am looking for. I have a tutorial on my page which shows how to execute PL/SQL from DBI. Alternatively, you can always execute using system(). The command perldoc -f system will tell you how to execute sqlplus from within the Perl interpreter. If my question is not too brazen, why would you want to call sqlplus, when DBI is much more convenient and can be used for programming, in contrast with sqlplus internal variables? -- http://www.mgogala.com