On Mon, Aug 15, 2005 at 04:00:06PM +0200, H.Merijn Brand wrote: > On Mon, 15 Aug 2005 14:21:15 +0100, Tim Bunce <[EMAIL PROTECTED]> wrote: > > > On Mon, Aug 15, 2005 at 03:12:21PM +0200, H.Merijn Brand wrote: > > > I'm in the process of trying to have foreign_key_info () implemented on > > > DBD::Unify, and replacing DBD::Unify::db::link_info () with the correct > > > equivalent. > > > > > > foreign_key_info () accepts either 6 or 7 arguments, of which the third > > > and the sixth are a table name. > > > > > > DBD::Oracle does *NOT* return any information if I pass the table name in > > > the form I originally created the table with: Lower Case. > > > > Because Oracle normalizes unquoted names to uppercase. > > I know that is not your/DBI's fault > > > > My call now looks like: > > > > > > my $stl = $dbh->foreign_key_info (undef, undef, undef, undef, $schema, uc > > > $table); > > > > > > which looks bloody stupid. > > > Bug? > > > > No. > > Anyway to make this work *portable* ?
Not sure. Ask the ODBC folk. Tim. > e.g. Unify normalizes everything to as it was entered :) > in Oracle all other operations work quite ok when using lower case > table/column names: select, drop, create, ... > > <rant> > /me just hat to raise the hatred level for Oracle even beyond what /me > already thought was way to high for something so widely accepted. > </rant> > > -- > H.Merijn Brand Amsterdam Perl Mongers (http://amsterdam.pm.org/) > using Perl 5.6.2, 5.8.0, 5.8.5, & 5.9.2 on HP-UX 10.20, 11.00 & 11.11, > AIX 4.3 & 5.2, SuSE 9.2 & 9.3, and Cygwin. http://www.cmve.net/~merijn > Smoking perl: http://www.test-smoke.org, perl QA: http://qa.perl.org > reports to: [EMAIL PROTECTED], [email protected]
