Home » Developer & Programmer » Forms » FORMS Page quit while executing query. (Oracle 12c, windows 2012)
FORMS Page quit while executing query. [message #647165] Wed, 20 January 2016 23:08 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi All,

Having a issue, which is not showing any error message.

1) Below query is working fine in TOAD and SQLPLUS, but not working in FORMS.

UPDATE <table name>@<link name>
				SET CAS_VCH_NO = :bl_pfrda_dtl.cas_vch_no
				    ,CAS_VCH_UP_DATE = l_vvch_dt,
				    CAS_VCH_VALUE_DATE = l_vvalue_dt
				WHERE transid = :bl_pfrda_dtl.transid
				AND entrydate = :bl_pfrda_dtl.entrydate;


2) The DB version is Oracle 12c, the FORMS version is 11.1.2.1.0.

3) When we try to do, the FORMS page get exit automatically, without showing any error message.

4) This query using the DB link, which is connecting to the SQLSERVER through HS. Working fine in TOAD and SQLPLUS.

Thanks and Regards
Muktha
Re: FORMS Page quit while executing query. [message #647170 is a reply to message #647165] Thu, 21 January 2016 02:57 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Can you move it into a stored procedure?
Re: FORMS Page quit while executing query. [message #647172 is a reply to message #647170] Thu, 21 January 2016 04:11 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Cookiemonster,

Yes, it is inside the PROCEDURE only.

Thanks
Muktha
Re: FORMS Page quit while executing query. [message #647175 is a reply to message #647172] Thu, 21 January 2016 04:26 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
A DB stored procedure, not a forms one
Re: FORMS Page quit while executing query. [message #647177 is a reply to message #647175] Thu, 21 January 2016 04:28 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could also try creating a synonym for <table name>@<link name> and reference that instead.
Re: FORMS Page quit while executing query. [message #647194 is a reply to message #647177] Thu, 21 January 2016 23:50 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Cookiemonster,

We tried initially with synonym, didn't work out.

But now tried with Stored Procedure, working fine.

What could be the reason for this?

Thanks
Muktha
Re: FORMS Page quit while executing query. [message #647196 is a reply to message #647194] Fri, 22 January 2016 03:22 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Some form of oracle bug that causes the forms engine to not play nicely with DB links.
Re: FORMS Page quit while executing query. [message #647200 is a reply to message #647196] Fri, 22 January 2016 06:02 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Cookimonster,

Thanks for your help.

Regards
Muktha
Previous Topic: Java Calendar
Next Topic: to display a progress bar in oracle form processing
Goto Forum:
  


Current Time: Fri Jul 10 14:17:08 CDT 2020