Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change report via radio group in Oracle APEX using if statement

User_M4XGBDec 20 2022

I am trying to dynamically change what a report displays based on what is selected in a radio group.

   if :p33_RG = 'Daily' then
        select project_name, to_char(date_sys, 'MM/DD/YYYY') as Day,      
    sum(BATCH.RECORDS_NUMBER) as Count_of_Documents
    from BATCH
    where date_sys between :P33_START_DATE and :P33_END_DATE
    group by project_name, to_char(date_sys, 'MM/DD/YYYY');
   else if
    :p33_RG = 'Weekly' then
    select project_name, to_char(TRUNC(date_sys, 'IW'), 'MM/DD/YYYY') as WEEK, 
    sum(BATCH.RECORDS_NUMBER) as Count_of_Documents
    from BATCH
    where date_sys between :P33_START_DATE and :P33_END_DATE
    group by project_name, TRUNC(date_sys, 'IW');
   end if;

however I am getting multiple errors when I try to run this. Any suggestions on how I can change the script?

Comments

EJP
http://forum.java.sun.com/thread.jspa?threadID=748677.

Also you must use the same ObjectOutputStream and ObjectInputStream for the life of the socket.
843790
but how come sometimes I have this error and sometimes it works perfectly fine ?
EJP
Because of the occasional network transmission problems I discussed in the thread I referred you to.
843790
Thanks for the thread link.. interesting description.. ;)
so is there any way to solve this issues..?
if you look at the code, basically what im trying to do is the following:
- a client connect to a server using sslsocket.
- server receive the connection and reply with the first part of the data and keep the connection open.
- then client receive the reply and request for another data using the same socket connection
- then server receive the next request and reply with the second part of the data and close the connection when the loop is finish.

what im trying to do is actually to chunk the download size. consider I need to download a 20MB of data from the server, using a single request is fine, but client have to wait for sometime until all the data is downloaded. so im trying to chunk the data into several part, and the server will send the chunk of data one by one. so the moment client receive the first part of the data, it will display it directly and at the same time will process the next data.

creating a new socket request for each chunk of data will be slow since it has to keep open and close the socket to server several times.

so in short, im trying to utilize one socket connection to do several data communication between client and server.
can you help point out what i did wrong in doing this..? or a link to any site providing example in doing this..?

Thanking you in advance for your help and sorry for the length of the post.. :)
EJP
Nothing wrong with what you're doing. There is a problem in the network somewhere.
1 - 5

Post Details

Added on Dec 20 2022
#apex, #apex-discussions, #sql
3 comments
208 views