[Dbix-class] dbix-class doesn't seem to be getting server info for oracle ...

Peter Rabbitson rabbit+dbic at rabbit.us
Thu Oct 20 12:00:08 GMT 2011


On Tue, Oct 18, 2011 at 12:56:05PM -0400, Ronald Straight wrote:
> This is rather convoluted, and far easier using regex in more recent
> versions, but since you're checking for gt 8, it won't be available.  So,
> you can use the following SQL.
> 
> with vb as
>  ( select banner,
>              instr(banner,'Release') + length('Release') + 1 as istart,
>              instr(banner, '-') - 1 as iend
>    from v$version
>    where banner like '%Oracle%' )
> select substr(vb.banner,vb.istart,vb.iend-vb.istart) from vb;
> 
> Or try upgrading.  :)


Was this directed at the OP or at the DBIC team? He already is using latest
DBIx::Class, hence my confusion :)



More information about the DBIx-Class mailing list