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:amaresh.poth...@gmail.com] Sent: Monday, November 19, 2012 3:29 AM To: dbi-users@perl.org 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
