We help IT Professionals succeed at work.
Get Started

select and insert in store proc

royjayd
royjayd asked
on
443 Views
Last Modified: 2012-08-14
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
Comment
Watch Question
IT-specialist
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 3 Answers and 3 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE