The corresponding data type for "images" in Oracle is LOB/BLOB. First, I create a table with BLOB data types in Oracle, then, I execute the store procedure, But I got the error message: "ora-22992 cannot use LOB locators selected from remote tables"
You need to use either JAVA or some OCI to load LOB data from SQL Server to Oracle. PL/SQL proc will fail if the size of LOB > 32K.

Tamil