On Tue, 2002-12-03 at 16:20, Steve Baldwin wrote: > I'm sure this has been asked many times before, but Tim's reply here > prompted me to ask again. Is there any way to access the DB version (as > per your example of get_info(18) below) from DBI. For example as an > attribute of the database handle. I've consulted the manual, but > couldn't find any reference to this. We currently have a requirement to > support Oracle 7.3 and 9i, and in some cases the SQL we execute needs to > be different (to take advantage of 9i features). At present we obtain > the version ourselves by issuing : > "select banner from v$version", and parsing the appropriate bits out. I > reckon it would be nicer (and presumably more portable) if the DBD layer > could expose this info.
Well, the easiest way would be to roll your own extended class from DBI, and just add the version as a new method. -- Jeff Boes vox 616.226.9550 ext 24 Database Engineer fax 616.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise