Ask the Expert

ORA-28500 with database link

I created a database link from Oracle 10g to MS SQL Server. It works. I can select from tables on SQL Server. In one table there is a column name larger than 30 characters. I don't select this column but I get this error: "ORA-28500: Attempt to access a column Address_OutputMedium_Caption_ID with unsupported name length (greater than 30 characters)." I can't change the name of this column. What can I do? Thank you very much for your help.

    Requires Free Membership to View

You cannot force Oracle to query any table that has a column name longer than 30 characters, even if that table is stored in a database system that allows longer column names, like SQL Server. About the best you can do is to create a view in SQL Server that queries the table. This view would change the column name.
CREATE VIEW my_table_view (column1,column2,
   column3_less_than_30)
AS SELECT column1,column2,column3_is_much_much_much
   _much_much_longer_than_30_characters
FROM my_table;
In Oracle, you query the view, which pulls data from the table.

This was first published in August 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: