Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 59461
Status: rejected
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: RUZ [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.24b
Fixed in: (no value)



Subject: column_info is case sensetive
Download (untitled) / with headers
text/plain 244b
Hello, It took me a while to figure out that column_info actually works, but is case sensetive and Oracle thinks that upper case is cool. Could you please either document this or make search query case insensetive. -- Best regards, Ruslan.
Download (untitled) / with headers
text/plain 693b
Column_info simply runs an sql to get the info. Normal an oracle DB does not care about the 'case' of a table or row name however oracle does allow you to do this create table "BlaB" ("Bla_BLA" COL1 NUMBER) and that will hardcode your table and field name so only this SQL will work Select Bla_Bla from BlaB while if you created your table like this create table BlaB (Bla_BLA COL1 NUMBER) then Select Bla_Bla from BlaB Select BLA_BLA FROM BLAB select bla_bla from blab will all work most likely you are running into this. Basically there is no way around this to get the table info even in say SQlPlus you would have to use the name of the field that created in this manner.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.