Re: Perl DBI Hangs while execute()

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 <[email protected]> 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: [email protected]
> > Date: Mon, 19 Nov 2012 16:59:09 +0530
>
> > Subject: Perl DBI Hangs while execute()
> > To: [email protected]
>
> >
> > 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
>