Perl DBI Hangs while execute()

[amaresh pothnal]

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

[Nelson, Erick [HDS]]

There are many things you can do in sqlplus that you cannot do in sql (in this case DBI).
What are you trying to run?

[amaresh pothnal]

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 <byte...@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...@gmail.com
> > Date: Mon, 19 Nov 2012 16:59:09 +0530
>
> > Subject: Perl DBI Hangs while execute()

> > To: dbi-...@perl.org