select and insert in store proc

higuys

I have this following requirment.I am using Oracle 9i and these are the tables i  am using

Database1
Table  Customer_Profile
Columns
Name
Id
Stock_Quote#

Database2
Table  Cus_Profile
Columns
Cus_Name
Cus_Id
Stock_Quote#

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.

thanks