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