OraFAQ Forum: Forms » FORMS Page quit while executing query.

Home » Developer & Programmer » Forms » FORMS Page quit while executing query. (Oracle 12c, windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FORMS Page quit while executing query. [message #647165]

Wed, 20 January 2016 23:08

muktha_22
Messages: 527
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

Report message to a moderator

Re: FORMS Page quit while executing query. [message #647170 is a reply to message #647165]

Thu, 21 January 2016 02:57

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Can you move it into a stored procedure?

Report message to a moderator

Re: FORMS Page quit while executing query. [message #647172 is a reply to message #647170]

Thu, 21 January 2016 04:11

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Cookiemonster,

Yes, it is inside the PROCEDURE only.

Thanks
Muktha

Report message to a moderator

Re: FORMS Page quit while executing query. [message #647175 is a reply to message #647172]

Thu, 21 January 2016 04:26

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

A DB stored procedure, not a forms one

Report message to a moderator

Re: FORMS Page quit while executing query. [message #647177 is a reply to message #647175]

Thu, 21 January 2016 04:28

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You could also try creating a synonym for <table name>@<link name> and reference that instead.

Report message to a moderator

Re: FORMS Page quit while executing query. [message #647194 is a reply to message #647177]

Thu, 21 January 2016 23:50

muktha_22
Messages: 527
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

Report message to a moderator