OraFAQ Forum: Forms » Parse Message

Home » Developer & Programmer » Forms » Parse Message (oracle 11g)

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

Parse Message [message #640400]

Tue, 28 July 2015 01:27

Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi

Member

Hi Experts.

In use following code
*******************************
GO_ITEM ('PAS_POLBENEFICIARY.NGU_GUARDCD');

DECLARE
CURSOR C1 IS
SELECT C.PGU_NAME FROM
PAS_POLBENEFICIARY X,PAS_POLGUARDIAN C
WHERE X.PPB_PROPOSAL=:PAS_POLBASIC.PPB_PROPOSAL
AND X.PPB_PROPOSAL=C.PPB_PROPOSAL
AND X.NGU_GUARDCD=C.PGU_GUARDCD
AND X.NGU_GUARDCD=:PAS_POLBENEFICIARY.NGU_GUARDCD;

BEGIN

FOR I IN C1 LOOP
:PAS_POLBENEFICIARY.GURDIAN:=I.PGU_NAME;
NEXT_RECORD;
END LOOP;
FIRST_RECORD;
:System.Message_Level := '20';

EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
END;

*******

it is work fine but when loop complete then showing message
Last record of query retrieve.
i want to hide this message. i am also use
:System.Message_Level := '20';
but it is not working.... how can i do ?

Report message to a moderator

Re: Parse Message [message #640407 is a reply to message #640400]

Tue, 28 July 2015 02:45

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

Senior Member

Please read and follow How to use [code] tags and make your code easier to read?
What trigger is this code in?
Get rid of the exception handler, it'll never be used. For loops will never throw no_data_found.

Report message to a moderator

Re: Parse Message [message #640411 is a reply to message #640407]

Tue, 28 July 2015 04:56

Nasir.azeem
Messages: 40
Registered: September 2014
Location: Karachi

Member

When_New_block_instance

Report message to a moderator

Re: Parse Message [message #640435 is a reply to message #640411]

Tue, 28 July 2015 08:57

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

Senior Member

Why are you not using the default query functionality to populate the block?

Report message to a moderator

Re: Parse Message [message #640437 is a reply to message #640435]

Tue, 28 July 2015 09:00

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

What is the actual message you are receiving? If it is a FRM-40352 then you can trap and suppress this message in the On-Error or On-Message triggers.

I agree with CM, looking your code, why not use a From Clause Query based block or at the least you could use a JOIN in your block "Query Data Source Name" property. Both types of block data sources are non-updatable, however.

Craig...

Report message to a moderator

Previous Topic:	set_item_property..
Next Topic:	Re: FRM-40501 unable to reserve record for update or delete

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 06:45:47 CDT 2024