OraFAQ Forum: Forms » select one server data and this result insert another server table

Home » Developer & Programmer » Forms » select one server data and this result insert another server table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select one server data and this result insert another server table [message #250203]

Mon, 09 July 2007 02:11

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

Hi,
I have two server.one is live and another is testing
i create a table in testing server.i create a procedure this
procedure
select some column in live server table and
insert this column in testing server table and
my form is always connect testing server.......i have use db link

sample
select name@live_link into nname from tam

insert into tamm
values(nname);
when i compile this procedure,my form enviroment is automatic
session out.

masud raihan(BracBank(Dhaka,Bangladesh)

Report message to a moderator