RE: Perl DBI Hangs while execute()

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?

-----Original Message-----
From: amaresh pothnal [mailto:[email protected]] 
Sent: Monday, November 19, 2012 3:29 AM
To: [email protected]
Subject: Perl DBI Hangs while execute()

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