Home » Developer & Programmer » Forms » Data Block Empty (Oracle Forms 10g)
icon9.gif  Data Block Empty [message #674503] Wed, 30 January 2019 04:28 Go to next message
alialzaabi88
Messages: 4
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 !!

Re: Data Block Empty [message #674512 is a reply to message #674503] Wed, 30 January 2019 07:58 Go to previous messageGo to next message
joy_division
Messages: 4940
Registered: February 2005
Location: East Coast USA
Senior Member
go_block('') will go nowhere, so execute_query will only query your current block.
Re: Data Block Empty [message #674523 is a reply to message #674512] Wed, 30 January 2019 21:50 Go to previous messageGo to next message
alialzaabi88
Messages: 4
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.
Re: Data Block Empty [message #674524 is a reply to message #674523] Thu, 31 January 2019 03:26 Go to previous messageGo to next message
cookiemonster
Messages: 13451
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.
Re: Data Block Empty [message #674530 is a reply to message #674524] Thu, 31 January 2019 08:36 Go to previous messageGo to next message
alialzaabi88
Messages: 4
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.
Re: Data Block Empty [message #674531 is a reply to message #674530] Thu, 31 January 2019 09:06 Go to previous messageGo to next message
cookiemonster
Messages: 13451
Registered: September 2008
Location: Rainy Manchester
Senior Member
Same DB link each time or different ones?
Re: Data Block Empty [message #674532 is a reply to message #674531] Thu, 31 January 2019 09:08 Go to previous messageGo to next message
cookiemonster
Messages: 13451
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?
Re: Data Block Empty [message #674533 is a reply to message #674532] Thu, 31 January 2019 09:10 Go to previous messageGo to next message
cookiemonster
Messages: 13451
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?
Re: Data Block Empty [message #674571 is a reply to message #674533] Sat, 02 February 2019 11:24 Go to previous messageGo to next message
alialzaabi88
Messages: 4
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 .
Re: Data Block Empty [message #674576 is a reply to message #674571] Mon, 04 February 2019 04:01 Go to previous messageGo to next message
cookiemonster
Messages: 13451
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?
Re: Data Block Empty [message #674682 is a reply to message #674576] Sat, 09 February 2019 10:41 Go to previous message
Littlefoot
Messages: 21457
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.
Previous Topic: Canvas not showing
Next Topic: Hindi/Bangla Language in Forms 6i
Goto Forum:
  


Current Time: Fri Feb 15 20:18:07 CST 2019