CODEWITHSUNDEEP
oracle-databaseoracle12cinformaticainformatica-powercenter
Hemanth Kumar
Hemanth Kumar

Reputation: 13

Getting ORA-00904: "DECL_OBJ#": invalid identifier while loading data using informatica tool in oracle

Can someone please help to resolve the below error which is occuring while trying to insert records from Oracle Database A to Database B using Informatica tool:

ORA-00904: "DECL_OBJ#": invalid identifier

Upvotes: 0

Views: 2620

Answers (1)

Francisco
Francisco

Reputation: 51

I had this error with SQL Developer.

Tools --> Preferences --> Database --> PL/SQL Compiler

PLScope Identifiers : None

Set to None

Upvotes: 3

Related Questions