I have this following requirment.I am using Oracle 9i and these are the tables i am using
Data from table Customer_Profile (of Database1) needs to be fetched and inserted into Cus_Profile(of Database2)
We want to use Oracle stored procedure to do this using a oracle refcursor.
create or replace package customertrading.Customer_profile_storeProc
define ref cursor here ?
SELECT * from Customer_Profile
INSERT into Cus_Profile (..)
I dont have much experience with oracle stored procs so was wondering how i should proceed.
Any help will be appreciated.