[Dbix-class] dbix-class doesn't seem to be getting server info
for oracle ...
Ronald Straight
quinnfazigu at gmail.com
Tue Oct 18 16:56:05 GMT 2011
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. :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20111018/c23=
c76f7/attachment.htm
More information about the DBIx-Class
mailing list