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* ? 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]
