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!

read the data from ms-sql and load into oracle 12.1 for CLOB column

User_K2IRAJul 19 2022 — edited Jul 19 2022

Hi,
As check your comments you made changes in 12.2 version, is it possible to made the same changes in 12.1.
SQL server : having a column with datatype(varchar(max))
Oracle 12.1-> data needs to load into my_tab having a column with datatype(varchar/CLOB)
I'm trying manyways but showing an error : illegal use of Long datatype
Please help

Added on Jul 19 2022

4 comments

353 views