Stored procedure in oracle

[riyap]

hi
can anyone help me to simplify my logic in writing code,
i have ms acess database table.i want to get the data from there(using select command with where clause) and insert into a stored procedure in oracle database.
stored procedure package has 8 i/p fields and 1 output feilds.
when i insert fields i need to get the o/p value from it and update it into ms acess DB table.

My doubt is how to get data from Acess and enter into stored procedure in oracle

Please give me suggestions , it will be a great help for me

Thanks in Advance

[QVeen72]

Hi,

Use "Microsoft ActiveX Data Objects" library
Declare 2 Connections and 2 Recordsets and a CommandObject.
Connect one Conn to Access and the other to Oracle.
Check For Connection Strings
get Data from Acc Con
Pass parameters to Command object (with active oracle conn).
Execute the stored procedure
To Execute Stored Procedure Check this
and get back the data and update
your access database..


Regards
Veena

[debasisdas]

Find about stored procedure in oracle here.

[riyap]

Thanks For your help
Il have a look at it

[riyap]

Find about stored procedure in oracle here.

i understood the oracle procedure
but only question is after excuting the acess db query, how do i assign those values(each field values) to the parameters im passing into oracle procedure
i.e value=???
how do i give the access feilds values to oracle parameters and pass it
Kindly help me
ur help is appreciated