OraFAQ Forum: Forms » Data Block Empty

Home » Developer & Programmer » Forms » Data Block Empty (Oracle Forms 10g)

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

Data Block Empty [message #674503]

Wed, 30 January 2019 04:28

alialzaabi88
Messages: 6
Registered: January 2019

Junior Member

Dear All,

I am new in Oracle Forms , I try to create one Query System, but i am facing an issue while retrieve the data.

My System has 14 Canvas.
I have 15 Data Blocks.

I Create one Block with 19 Items and each item has triggers ( when button pressed ).

in Trigger i have two things:-

1/ go_block('');
2/ Execute_query;

This is a summary of the system.

Now the issue that i faced when i click on item i get data for some of them. if i click A & B & C & D then click F --> F become empty no data shown

, but if I click on B & C & D & F then Go to A --> A become empty no data shown.

Please if there is any limitation in Oracle forms or i am doing something wrong Help !!

Report message to a moderator

Re: Data Block Empty [message #674512 is a reply to message #674503]

Wed, 30 January 2019 07:58

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

go_block('') will go nowhere, so execute_query will only query your current block.

Report message to a moderator

Re: Data Block Empty [message #674523 is a reply to message #674512]

Wed, 30 January 2019 21:50

alialzaabi88
Messages: 6
Registered: January 2019

Junior Member

Joy , thanks for replay.

My Issue not with go_block or execute query because i was create one object with all execute query with 13 data blocks , but the data shown only for first 10 data blocks.

So i was thinking that the issue because i am putting many execute query in one trigger ( when button pressed ).

but now i create 13 items each item has execute query with block name.

as i said before this what happening

if i click A & B & C & D then click F --> F become empty no data shown

, but if I click on B & C & D & F then Go to A --> A become empty no data shown.

Report message to a moderator

Re: Data Block Empty [message #674524 is a reply to message #674523]

Thu, 31 January 2019 03:26

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

Senior Member

I'm not aware of any limits on the amount of queries you can execute. Though I've never created a form with that many blocks to see what happens.
You're going to have to debug it.
Put messages in pre and post-query on all the blocks to see if they fire.
Trace the database session to see what select statements are sent to the DB.

I'd see what that gives before making any more suggestions.

Report message to a moderator

Re: Data Block Empty [message #674530 is a reply to message #674524]

Thu, 31 January 2019 08:36

alialzaabi88
Messages: 6
Registered: January 2019

Junior Member

I think i found the issue , because i am using db-link to fetch the data from.

i try to create many table in db it's OK ,but the data that coming from db-link only four execute query works.

if anyone have suggestion. lets me know

Thanks for everyone.

Report message to a moderator

Re: Data Block Empty [message #674531 is a reply to message #674530]

Thu, 31 January 2019 09:06

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

Senior Member

Same DB link each time or different ones?

Report message to a moderator

Re: Data Block Empty [message #674532 is a reply to message #674531]

Thu, 31 January 2019 09:08

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

Senior Member

Which is to say - how many blocks use a db link? and do they all use the same db link?
If they use different DB links then is it always the same link that's causing the issue?
Or does it stop working after a number of links are accessed and which ever comes last is the one that stops working?

Report message to a moderator

Re: Data Block Empty [message #674533 is a reply to message #674532]

Thu, 31 January 2019 09:10

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

Senior Member

Have you checked the alert log to see if there are any db link related errors in there?

Report message to a moderator

Re: Data Block Empty [message #674571 is a reply to message #674533]

Sat, 02 February 2019 11:24

alialzaabi88
Messages: 6
Registered: January 2019

Junior Member

I am using Three different dink , all looks fine because from toad I am checking data featching fine , but in oracle forms only four execute query works .

Report message to a moderator

Re: Data Block Empty [message #674576 is a reply to message #674571]

Mon, 04 February 2019 04:01

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

Senior Member

cookiemonster wrote on Thu, 31 January 2019 15:08

Which is to say - how many blocks use a db link?
If they use different DB links then is it always the same link that's causing the issue?
Or does it stop working after a number of links are accessed and which ever comes last is the one that stops working?
....
Have you checked the alert log to see if there are any db link related errors in there?

Report message to a moderator

Re: Data Block Empty [message #674682 is a reply to message #674576]

Sat, 09 February 2019 10:41

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes, I know - I'm late, but can't resist: you are new to Forms, and yet decided to create a form with 14 canvases and 15 data blocks. Whoa! I can't remember I ever created a form with more than 2-3 canvases.

Anyway: a suggestion, if I may: consider using a tabbed canvas which allows you to create several tabs, each of them can contain its own data block. Maybe it'll be simpler to maintain than your current layout.

Report message to a moderator

Previous Topic:	Canvas not showing
Next Topic:	Hindi/Bangla Language in Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 15:14:15 CDT 2023