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