Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Perl DBI, Oracle truncating 30th character from the column name.

by Anonymous Monk
on Nov 26, 2021 at 11:14 UTC ( #11139143=perlquestion: print w/replies, xml ) Need Help??

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

While fetching data from Oracle db using Perl DBI, since column name is lengthy enough, oracle is truncating the 30th character from the column name, because of it's column length restriction it seems.

Is there anything we can do using perl DBI to avoid this column name truncation from the result set.

Thank you

  • Comment on Perl DBI, Oracle truncating 30th character from the column name.

Replies are listed 'Best First'.
Re: Perl DBI, Oracle truncating 30th character from the column name.
by marto (Cardinal) on Nov 26, 2021 at 11:21 UTC

    Pre Oracle v12.2 30 bytes was the limit, post v12.2 this is no longer the case. If you built DBD::Oracle against a pre v12.2 database and have since upgraded you should rebuild against the updated database/clients. If you need more help please read and understand How do I post a question effectively? before responding, more details will be required.

      Hi Marto,

      Thank you for the revert. Oracle version i have is 19c, but driver i am using is ODBC and not DBD, could it be the issue.

      Let me check that link you provided on how to ask question effectively

      Regards

        If you are using ODBC in windows ensure your Oracle driver is up to date. Update: I assume you don't experience this problem using sqlplus directly?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://11139143]
Approved by marto
Front-paged by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (3)
As of 2022-05-19 02:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you prefer to work remotely?



    Results (71 votes). Check out past polls.

    Notices?