Ana
Ana

Ana

View Profile
  • 2
Professional
Asked:
  • 2

Hello Sir:) I want to create read only form, which retrieves data from the table. For that I created a region of type form and used SQL-Query as source. The page is rendered as read only always. But now I get displayed empty items, do I have to insert for each page item a default value type for example (sql-query) in order to set the item? or is there a better solution for this?

apexformoracleread-only
Ana
Ana

Ana

View Profile
  • 0
Professional
Asked:
  • 0

Hello Sir, to retrieve the status of a form from the logged in user, I did the following: -  created application item 'STATE_OF_FORM'. - created application process to set the value into the application item this takes the status from a table and should set it in the application_item. Unfortunately it doesn't work as hoped, I think the error is in the syntax: --this is the code to set stored table status into the status application item declare v_state varchar2(50); begin select fp.STATE into v_state FROM PROCESSSTEPS_FORM fp left outer join USERS u on fp.UUID=u.UUID where u.username=:APP_USER; Apex_Util.Set_Session_State('STATE_OF_FORM', v_state); --exception handling needed otherwise the error 'ORA-01403: no data found' will exception be raised when no_data_found then NULL; end; What do I do wrong?

applicationitemprocess
Richmond
Richmond

Richmond

View Profile
  • 0
Professional
Asked:
  • 0

Dear Colleagues, i have a requirement to automated sms alert on birthdays but my code (loop) sends out alot of messages to clients on the day of birthday. i need a simple code to fetch contacts of this employees who are celebrating their bday on sysdate and send sms using my api. Please find my sample code which works but the send a lot of sms to one client. This is done using apex automation feature Thank you     Declare api sms_api.sms_api%TYPE; l_clob  CLOB; list_con varchar2(2000); message_confirmed varchar2(4000); BEGIN SELECT SMS_API INTO api FROM SMS_API WHERE COMPANY = 'HMI'; FOR rec IN (select CLIENTS_HMI.CONTACT as CONTACT, CLIENTS_HMI.FIRSTNAME from CLIENTS_HMI CLIENTS_HMI where add_months(DATE_OF_BIRTH, 12 * round((trunc(sysdate) - DATE_OF_BIRTH)/365.25)) between trunc(sysdate) + 0 and trunc(sysdate) + 0) LOOP l_clob := apex_web_service.make_rest_request( p_url => 'https://sms.arkesel.com/sms/api?action=send-sms&api_key='||api||'&to='||rec.CONTACT||'&from=HMI-INVEST&sms=Happy Birthday '||rec.FIRSTNAME||', We at (HMI Management Services) wish your birthday will be as awesome as you have been to our business. We wish you the best as you celebrate today. Enjoy your day!!!', p_http_method => 'GET'); END LOOP; END;

apex_automationlooporacle apexsms
Ana
Ana

Ana

View Profile
  • 1
Professional
Asked:
  • 1

Hello 🙂 I would like to create a history table in my application, which should indicate when which user has done what. For now, I have created an audit table and a trigger that enters the necessary data into this table after an UPDATE, DELETE or INSERT on the specific table. In the history table, however, I want to log every process step and fill it with the information WHO did WHAT WHEN and display it. This table should be updated in the course of the process, so that one can see which steps have already been taken and by whom. But now I am not sure how to create such a history table database-wise, because I want to log every process step executed by any user and display it in the history tab. Should I create a trigger for this as well and a table for each process step (although that would probably be a bad database design). I'm not asking for any code here, just a hint if it's possible and in best case some keywords so I can search for ...

apexoracletrigger