printing from apex using pl/sql

As part of our exercise to convert an excel spreadsheet to APEX, we ran into some simple logic that required more logic and less database select statements. The question comes up how to do an if – then – else statement in APEX. In this example we are trying to advise between using compute on demand or dedicated compute resources. With dedicated compute resources, we can purchase 50 OCPUs as an aggregate. With dedicated we can go as low as 1 OCPU. If we request 14 systems with 4 OCPUs it might be better to request 50 OCPUs.

A typical question form would look like the following image allowing us to ask processor shape as well as quantity. If the total mount exceeds, 50 processors, we output a message suggesting dedicated compute rather than compute on demand.

To get this message on the screen, we first had to pull in the questions that we ask using variables. In this example, we read in the UNMETERED_COMPUTE_SHAPE which is a pick list that allows you to select (1, 2, 4, 8, or 16) OCPU shapes. You can also type in a quantity number into UNMETERED_COMPUTE_QUANTITY. The product of these two values allows us to suggest dedicated or compute on demand for economic reasons.

To execute pl/sql commands, we have to change the content type. To create this area we first create a sub-region. We change the name of the sub-region to represent the question that we are trying to answer. For this example we use the title “Compute on Demand vs Dedicated Compute” as the sub-region header. We then change the type to “PL/SQL Dynamic Content”. Under this we can then enter our dynamic code. The sub-region looks like

If you click on the expand button it opens a full editor allowing you to edit the code. In our example we are going to read the variables :UNMETERED_COMPUTE_SHAPE and :UNMETERED_COMPUTE_QUANTITY. Notice the colon in front of these names. This is how we treat the values as variables read from APEX. The code is very simple. It starts with a begin statement followed by an if statement. The if statements looks to see if we are allocating more than 50 processors. We then output a statement suggesting dedicated or compute on demand using the htp.p function call. This call prints what is passed to it to the screen. The code should look like
.

Overall, this is a simple way of outputting code that requires control flow. In the previous example we used a select statement to output calculations. In this example we are outputting different sections and different recommendations based on our selections. We could also set variables that would expose or hide different sub-regions below this section. This is done by setting :OUTPUT_VARIABLE = desired_value. If we set the value inside the pl/sql code loop, we can hide or expose sections as we did in a previous blog by setting a value from a pull down menu.

The code used to output the recommendation is as follows

BEGIN
if (:UNMETERED_COMPUTE_SHAPE * :UNMETERED_COMPUTE_QUANTITY > 50) THEN
htp.p('You might consider dedicated compute since you have '
|| :UNMETERED_COMPUTE_SHAPE * :UNMETERED_COMPUTE_QUANTITY
|| ' OCPUs which is greater than the smallest dedicated compute of 50 OCPUs');
else
htp.p('Compute on Demand for a total of '
|| :UNMETERED_COMPUTE_SHAPE * :UNMETERED_COMPUTE_QUANTITY || ' OCPUs');
end if;
END;

Post Views: 2,499

1,105 thoughts on “printing from apex using pl/sql”

  52. discount trazodone paxil pill desyrel 50 mg tablet can you order clomid online where can i buy metformin without a prescription 20mg cipralex medrol 4 pill albendazole 400 buy valtrex without prescription where can i buy advair diskus accutane 40 mg daily 400 mg zoloft buy generic augmentin online uk doxycycline 25mg tablets synthroid 0.025 mcg generic ivermectin for humans amoxicillin order online no prescription synthroid 15 mg neurontin cap 300mg stromectol without prescription

    Reply

  65. ivermectin brand purchase zoloft online where can you get diflucan over the counter clonidine trazodone 125 mg generic for paroxetine metformin 2018 plavix 75 mg daily augmentin 625mg tablets price in india amoxicillin capsule 500mg tablets ivermectin lice oral lexapro prescription online phenergan 25mg nz valtrex cleocin vaginal suppository trimox vardenafil 75 mg best online pharmacy for viagra online pharmacy birth control pills stromectol for sale

    Reply

  76. inderal 10mg buy online 25 mg phenergan tablets diflucan cost australia where to get amoxicillin over the counter bactrim antibiotic voltaren gel coupon canada zoloft 100mg medrol 500 mg diflucan cream over the counter levitra for sale australia gabapentin 300mg coupon where to buy advair diskus can you diflucan over the counter amoxicillin 125 mg tablet clomid uk cheap generic lexapro phenergan australia prescription synthroid 100 mcg online synthroid 700 mg zanaflex 2mg tablets

    Reply

  78. clindamycin 300mg capsules buy diflucan canada zoloft 5mg canadianpharmacyworld com clopidogrel cost uk inderal for sale uk vardenafil online no prescription where to get accutane acyclovir 500 mg tablet bactrim antibiotic online prescriptions amoxicillin no script zanaflex over the counter levitra where to buy online wellbutrin effexor buy phenergan over the counter clonidine .2 mg ivermectin goodrx buy diflucan uk how to buy stromectol buspar 5 mg

    Reply
  273. Pingback: bahis siteleri