troubleshooting Question

select and insert in store proc

Avatar of royjayd
royjayd asked on
Oracle Database
3 Comments3 Solutions444 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
flow01
IT-specialist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros