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;
Discy Latest Questions
Hello Sir! I would like to insert an entry into a column depending on the column of the same table. For that I thought of creating a trigger. This trigger checks which entry the certain column has in the table and then decides what to enter in another in the same table and in the same row. create or replace TRIGGER INSERT_COLUMN2_TABLE1 BEFORE INSERT OR UPDATE ON TABLE1 FOR EACH ROW begin -- IF :NEW.COLUMN ='REQUESTED' THEN :NEW.COLUMN2 := 'REQUEST_PENDING'; ELSEIF :NEW.COLUMN ='NOT_REQUESTED' THEN :NEW.COLUMN2:='TEXT123' END IF; END; but I get following errors when trying to execute the trigger: PLS-00103: Encountered the symbol "" when expecting one of the following: := . ( @ % ; PLS-00103: Encountered the symbol ";" when expecting one of the following: if as well I think this would be an after insert or update trigger? For the reason that it should be fired when an entry is already done in the column.. But how can I in general reference column in a trigger from the same table where I try to fire a trigger on? Maybe the better question is, how can one column value be populated based on another column in the same table. should I really use a trigger for that? --Used a virtual column for that ALTER table1 ADD ( column2 as ( case when column1 ...
Hello Sir, I have a general question. I would like to create a functiion to insert a value in a table depending on the action of the logged in user. This means when the user clicks on accept, then an entry should be made in the column like 'ACCEPTED'. But when the user clicks on the button denied, then another entry should be made like 'DENIED' in the column. I want then create processes in the page which call the different functions and are executed when a button is clicked. So for example for the button submit I call the function which makes an insert 'ACCEPTED' in the column of the table. For the button denied I call another function, which inserts another entry in the table etc. My general question is: how can different insertions be made in the table depending on the button actions? is the presented approach useful for such an issue?
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?
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 ...
Dear How Do I Restrict My Client By MAC Address if the connected user Mac Address in exist in table the login screen must show else no
I created a page there is open a popup/model and that is interactive grid. In same interactive grid, Need to write a validation which will show notification on popup page which will show there is some duplicate record. is it possible through JS or dynamic action?
Hy Good Morning I have report in my form When i open report in my monitor screen(P.C) As screensize of my P.C is more whole report is displayed in one page so it becomes easy for user to view the report,Same Report if i open in my smartphone as screensize is less user cannot view report in one whole screen,user has to scroll to and fro from left to right so it becomes difficut for user So i want to set resolution auto for all screensize,How Can i do it? Thank You...
Hi, in my table I have a column for a project which can have multiple project milestones (second column). Each of the milestone can have the value 'fullfilled' or 'pending' as current_status (third column). Now I want to aggregate the overall status of each project and assign it a final status (new virtual column) for better overview. The following rule should apply: If every milestone is fullfiled then the status of a project should change to 'Finished' If one or more milestones are pending then the status of project should be 'On-Hold' Meaning that I want to checklist every current status per project to get a final_status. Any idea how to do this with a case-when-clause or something similar? Thank you. Kind regards.
The QR code of the report will show the link of the report. Clicking on that Report link will show the report.