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: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

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: Tue Mar 11 10:47:46 CDT 2025