I have som problems with a load process
Hello guys, my problem is the next following:
Firts at all i will give you a little detail of my enviroment:
So bassically i have a RedHat Release 3 Update 4, my database is a Oracle 10G version 10.2.0.4.
I have to load the oracle database by a heterogenous services, from a SQL server over Windows to my database over Linux, i test all the configuration for that and everything works fine.
So i create a Store Procedure to load all the data from the SQL Server to Oracle like this, this is the source code:
create or replace procedure load_ofsa_tables is type table_array is table of fem_checking%rowtype index by pls_integer; v_data table_array; v_date varchar2(20); n_limit number := 100; errores number; err number; dmlerror_msg exception; error_counter number := 0; pragma exception_init(dmlerror_msg, -24381); cursor c_tbl_select is select * from ofsa_fem_checking@mshs; begin
So bassically i have a RedHat Release 3 Update 4, my database is a Oracle 10G version 10.2.0.4.
I have to load the oracle database by a heterogenous services, from a SQL server over Windows to my database over Linux, i test all the configuration for that and everything works fine.
So i create a Store Procedure to load all the data from the SQL Server to Oracle like this, this is the source code:
create or replace procedure load_ofsa_tables is type table_array is table of fem_checking%rowtype index by pls_integer; v_data table_array; v_date varchar2(20); n_limit number := 100; errores number; err number; dmlerror_msg exception; error_counter number := 0; pragma exception_init(dmlerror_msg, -24381); cursor c_tbl_select is select * from ofsa_fem_checking@mshs; begin
0