| How to get data from different database in form [message #329268] |
Tue, 24 June 2008 16:40  |
zhou6712
Messages: 1
Registered: May 2008
Location: Dallas TX
|
Junior Member |
|
|
Hello,
I have following codes in my form any try to get data from a different database. It turns to not form_success. The same statement execute well in pl/sql. how can I make it work in the from?
Thanks,
Joe
Declare
v_stmt varchar2(500);
v_from_login varchar2(100):='abc/logmein@dald';
v_this_login varchar2(100);='abc/letmein@dalt';
Begin
v_stmt := 'copy from '||v_from_login ||' to '||v_this_login||' insert joe_test using select * FROM joe_test; ';
forms_ddl(v_stmt);
IF NOT Form_Success THEN
message('v_error = '||sqlerrm);
else
message('Copy date successfully.');
end if;
End;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
