Discy Latest Questions

Richmond
Richmond

Richmond

View Profile
  • 1
Professional
Asked:
  • 1

Hi team, Can some convert this to pl/sql with dummy data.   Method: POST Endpoint: /v1.1/transaction/process //Request Headers Content-Type: application/json Authorization: Basic base64_encode('your API username:your API Key') Cache-Control: no-cache //Request Body { "account_number":"", "account_issuer":"MTN", "merchant_id":"Your Merchant ID", "transaction_id"=>"000000000000", "processing_code"=>"", "amount"=>"000000000020", "r-switch"=>"FLT", "desc"=>"Float Transfer Test", "pass_code"=>"Your Pass code" } Am having issue with utf-8 encoding. How do we set utf-8 encoding. Error: {"status":"Unprocessable Headers","code":400,"description":"UTF-8 Header encoding required"} CODE declare l_body CLOB; l_clob_bank CLOB; d_utl_to_raw varchar2 (2000); d_encode varchar2(2000); api varchar2(1000) := 'XXXXXX=:XXXXXX'; begin SELECT UTL_RAW.CAST_TO_RAW(api) into d_utl_to_raw FROM dual; SELECT UTL_ENCODE.BASE64_ENCODE(d_utl_to_raw) into d_encode FROM dual; l_body := '{ "account_number":"", "account_bank":"", "account_issuer":"", "merchant_id":"", "transaction_id":"", "processing_code":"", "amount":"000000000000", "r-switch":"FLT", "desc":"Float Transfer Test", "pass_code":"" }';         apex_web_service.g_request_headers(1).name := 'encoding';        apex_web_service.g_request_headers(1).value := 'utf-8';       apex_web_service.g_request_headers(2).name := 'Accept';       apex_web_service.g_request_headers(2).value := 'application/json; charset=utf-8';       apex_web_service.g_request_headers(3).name := 'Content-Type';       apex_web_service.g_request_headers(3).value := 'application/json; charset=utf-8';       apex_web_service.g_request_headers(4).name := 'Authorization';       apex_web_service.g_request_headers(4).value := 'Basic '||d_encode||'';       apex_web_service.g_request_headers(5).name := 'Cache-Control';       apex_web_service.g_request_headers(5).value := 'no-cache';         l_clob_bank := apex_web_service.make_rest_request(         p_url => 'URL',         p_http_method => 'POST',         p_body => l_body); if apex_web_service.g_status_code = 200 then    dbms_output.put_line('Service invoked successfully');     else     dbms_output.put_line('Service call failed with response code ' || apex_web_service.g_status_code); end if;  dbms_output.put_line(l_clob_bank); end;

apexapioracleweb services
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