Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How process longer column names in Oracle 11g

Gor_MahiaFeb 1 2024

Hi,

Is this a bug in Oracle 11g or something - why does it work as a single statement but not in plsql block?
I am referencing a remote dblink table with some columns more than 30characters limit (the source db server is higher version). However when i execute the below statement in sql developer or toad it works and insert data:

                1: this works,  
                 insert into tbl.PROJECTS\_TRANSFORMATION\_T     
                select \* from amz.tt\_project@link\_kprd ;  
                   
                   
                2: does not work in plsql block,  
                  
              **begin**

insert into tbl.PROJECTS_TRANSFORMATION_T
select * from amz.tt_project@link_kprd ;

end;

                Error report -  

ORA-06550: line 3, column 42:
PL/SQL: ORA-01948: identifier's name length (65535) exceeds maximum (30)
ORA-06550: line 3, column 22:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

Can someone please explain and whats the best approach to this issue if the actual source table is not altered to shorted the columns?

regards

This post has been answered by Solomon Yakobson on Feb 1 2024
Jump to Answer
Comments
Post Details
Added on Feb 1 2024
5 comments
567 views