This content has been marked as final. Show 5 replies
I wrote a solution in my blog:
Thank you so much for providing that soultion, it works beautifully!!
I have a small question.
I see that in your implementation you are using the two triggers on the block to set & reset the column & read new values.
Now I need to read the response from the table as soon as I click on a button.
I have no base table blocks. It's a simple read. I click a button & read the values in the table on to the form.
Q) Where do I need to call the "PRU_EMP" procedure in this case?( Here we clear the CLOB column and fetch new data) ??
In my button code this is what I am doing:
I believe the PRU_EMP should be within the loop in POQ_EMP correct?(i,e to reset the CLOB column)
Begin POQ_EMP; PRU_EMP; End;
Thanks a Lot.
I typically name my routines like the firing triggers:
So my POQ_EMP is reading the CLOB in a POST-QUERY-trigger
and the PRU_EMP is writing the CLOB in a PRE-UPDATE-trigger
I bet, that it's not a good idea to write a button which uses both procedures after each other.
When you have no basetable in your block, how did you fill your block?
Thanks for replying.
This application is used to interact with ASCII Terminal devices.
I send a command to a device & the device returns a response which gets updated to the database. From forms,I read the CLOB column which contains the device reponse.
A user inputs a command into a text field and hits a "Send" button, which sends the command the device and the response from the device gets updated into the database. This response is stored in the CLOB column where it is displayed in forms.
So there are no Base table blocks, just a simple UI to input a command and view the response from the table.
I need to read the response from the table after after I send a command to the device. ( This is in the "Send" Button of my application )
If you are using Oracle Forms in Oracle E-Biz environment, then using OAF you can display your CLOB data without any size limitations. A detailed solution is described on the following link
Edited by: Hiten Vira on Dec 11, 2012 6:55 AM