I HAVE A BIG PROBLEM, WHEN I`M IMPORTING DATA OF A REPOSITORY, ORACLE GIVE ME AN ERROR : ORA-01722
IF SOMEBODY KNOW, WHAT`S THE SOLUTION, PLEASE SEND ME AN E-MAIL.
THANK YOU
Printable View
I HAVE A BIG PROBLEM, WHEN I`M IMPORTING DATA OF A REPOSITORY, ORACLE GIVE ME AN ERROR : ORA-01722
IF SOMEBODY KNOW, WHAT`S THE SOLUTION, PLEASE SEND ME AN E-MAIL.
THANK YOU
According to metalink:
ORA-1722 always occurs because of SQL problem. Check for the followings:
1, The syntax of the query.
2, Check for data type conversion and make values passed to functions
have the
right data type.
So, I first check to make sure that the export completed sucessfully. Then, if the export file was ftp'd, redo the ftp making sure you ftp binary.