RE: Perl DBI Hangs while execute()

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