Thanks For your support. This issue got solved after installation of nls libraries. Thanks Amaresh
On Wed, Nov 21, 2012 at 5:53 AM, John Scoles <byter...@hotmail.com> wrote: > Well I would do something like > > select 1 from dual > > rather thatn '*' > > It sounds like your DB coonection string is not correct. > > Cheers > > > > > From: amaresh.poth...@gmail.com > > Date: Mon, 19 Nov 2012 16:59:09 +0530 > > > Subject: Perl DBI Hangs while execute() > > To: dbi-users@perl.org > > > > > Hi All, > > > > I am using Perl DBI to connect Oracle Database. > > The query runs if type from 'sqlplus' manually but hangs when I use the > > sql inside the script. > > Getting following error, > > "DBD::Oracle::st execute failed: ORA-36871: (XSFTDSC01) Object %s cannot > be > > used to define a column in a LIMITMAP. (DBD ERROR: OCIStmtExecute) [for > > Statement" > > > > And If remove that original query and replace 'select * from dual' and > > execute the script, > > I get 'Segementation Fault'. > > > > Please help me to solve this. > > Thanks > > > > -- > > Amaresh P >