Home » Developer & Programmer » Forms » Dynamic Database link (Oracle 10.2.0 Forms 6.0.8)
Dynamic Database link [message #661621] Sat, 25 March 2017 11:08 Go to next message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
Hi.

I have created mydblink1 already.


Declare
i varchar2(1):='1';
ans  number;
begin

Select sum(sal)
into ans
from emp@mydblink ||i;

end;


This is not working.

What is alternate method.

(Found via google that "Excecute Immediate" is used but in procedure, not in forms).

Any tip?

Re: Dynamic Database link [message #661624 is a reply to message #661621] Sat, 25 March 2017 11:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL statement must be known & fixed at compile time.
Re: Dynamic Database link [message #661631 is a reply to message #661621] Sat, 25 March 2017 12:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
(Found via google that "Excecute Immediate" is used but in procedure, not in forms).
Use DBMS_SQL.

Previous Topic: FRM-18222
Next Topic: Oracle forms Kerberos authentication
Goto Forum:
  


Current Time: Thu Mar 28 19:30:41 CDT 2024