OraFAQ Forum: Forms » Dynamic Database link

Home » Developer & Programmer » Forms » Dynamic Database link (Oracle 10.2.0 Forms 6.0.8)

Sat, 25 March 2017 11:08

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?

Sat, 25 March 2017 11:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL statement must be known & fixed at compile time.

Sat, 25 March 2017 12:14

Michel Cadot
Messages: 68352
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: Wed Feb 08 21:03:19 CST 2023