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

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.	[reply]
Re^2: Perl DBI, Oracle truncating 30th character from the column name. by Anonymous Monk on Nov 26, 2021 at 11:45 UTC
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	[reply]
Re^3: Perl DBI, Oracle truncating 30th character from the column name. by marto (Cardinal) on Nov 26, 2021 at 11:50 UTC
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?	[reply]
Re^4: Perl DBI, Oracle truncating 30th character from the column name. by Anonymous Monk on Nov 26, 2021 at 17:44 UTC
Re^5: Perl DBI, Oracle truncating 30th character from the column name. by marto (Cardinal) on Nov 26, 2021 at 19:18 UTC
Some notes below your chosen depth have not been shown here


P is for Practical
	PerlMonks