SOLVED: In my scenario, I'm calling the ORDs endpoint through the OCI API Gateway, so I have something like: OCI APEX -> OCI API Gateway -> ORDS Endpoint (On-Prem APEX on Tomcat/ORDS).

So, by default, withing APEX Restful Services, when REST-Enabling the Schema where the endpoint is, the sample API methods (Resource Templates) are created with an "/" at the end (e.g. "version/". Well, hard to believe but that "/" is the cause of the error (ORA-01031) in this case.

By simply removing the "/" from the name of the API methods everything works as expected.

I hope this may be useful for anyone to save some hours/days of frustration.

Thank you again John for this great article.

Hi John, thank you for this really great guide. I've done all the steps, trying to call an end-point from APEX on my OCI ADB and I get ORA-01031: insufficient privileges. In my case my principal is APEX_240100. The end-pont works fine from the browser or Postman, has no authentication required and it's an HTTPS address.

Any idea that can help me figure it out? Thanks a lot in advance.

Awesome and complete guide, appreciate your work, Jon!

Navigating the complexities of legal practice involves a great deal of precision and care, and I had always been diligent about securing my financial assets. Despite this, I found myself in a distressing predicament when I lost access to my Bitcoin wallet containing $300,000. The problem began when a computer crash wiped out my encrypted wallet file, leaving me unable to retrieve my funds. The situation was particularly dire as the money was crucial not only for personal savings but also for maintaining the financial stability of my practice .The initial panic was overwhelming. Despite my usual preparedness for any legal or financial issue, this felt like an insurmountable obstacle. I explored every possible solution, from consulting IT specialists to trying various recovery tools, but to no avail. My frustration grew as the days passed with no progress .During my search for help, I discovered DIGITAL HACK RECOVERY. Although I was initially skeptical, the gravity of the situation pushed me to give them a chance. From our first interaction, I was impressed by their professionalism and empathy. They understood the urgency of my case and were transparent about the recovery process. What stood out was their comprehensive approach. DIGITAL HACK RECOVERY didn’t just focus on recovering my wallet; they also provided valuable advice on enhancing my digital security. They introduced me to advanced encryption techniques and secure backup practices that I hadn’t previously considered. This not only helped in recovering my lost Bitcoin but also strengthened my overall financial security. The waiting period was fraught with anxiety and uncertainty. However, DIGITAL HACK RECOVERY kept me informed and reassured throughout the process. When they successfully recovered my wallet, the relief was immense. I felt a tremendous weight lifted off my shoulders and regained confidence in managing financial setbacks. This experience underscored the importance of having a robust backup plan and the right tools in place, no matter how prepared you think you are. Thanks to DIGITAL HACK RECOVERY, I not only regained access to my funds but also gained a deeper understanding of digital asset security. Their expertise and support were truly invaluable, and I wholeheartedly recommend their services to anyone facing similar challenges. If you ever find yourself in a bind, DIGITAL HACK RECOVERY is the team you need on your side .Reach out to DIGITAL HACK RECOVERY via their contact WhatsApp +19152151930

https :// digital hack recovery . com

digital hack recovery @ techie . com

SPEAK WITH A REASONABLE, LICENSED BTC/USDT RECOVERY HACKER - ALPHA KEY

After being unable to withdraw or send money from my block chain wallet address, I became a victim of a crypto investment scam. I found online reviews of Alpha Key Recovery's hacker expert services and how they have been assisting victims of scams involving cryptos. If you have fallen victim to any kind of scam, please contact them using the information below. They continue to be the most dependable crypto hacker that I can recommend to anyone.

WhatsApp Messenger: +15714122170 Signal Message: +18622823879 Alpha Key Recovery Telegram channel

I NEED A HACKER TO RECOVER MY LOST CRYPTOS VISIT [ ROCKET SPEED RECOVERY HACKER ]

My name is Emma Raducanu and I am from Toronto, Canada well known as a Professional Tennis Player. Have you fallen victim to a Ponzi scheme or are you having problems accessing your bitcoin wallet? For a 100% guarantee on the return of your wallet and any lost money, get in touch with ROCKET SPEED RECOVERY HACKER. In addition, ROCKET SPEED RECOVERY HACKER can help you with phone hacking, iCloud breaches, YouTube breaches, removing criminal records, and enhancing your university grades. Captain ROCKET SPEED RECOVERY HACKER has been helping people and businesses secure and retrieve stolen digital currencies like Eth and Bitcoin for years. contact them at...

WhatsApp .. +1 (269) 369–5436 Email… rocketspeedrecoveryhacker@seznam.cz Telegram..t.me/rocketspeedrecoveryhacker

very good

Buy Verified cash app Account. Buy UK, USA, CA, phone number and Bank verified and Card verified cash app account. 100% Guarantee.

➤Email: liveusatopseo@gmail.com ➤Skype: usatopseo ➤Telegram: @liveusatopseo ➤WhatsApp: +1 (405) 259-6692

Thanks for this excellent article!

Buy Verified Cash App Accounts - 100% Verified And Active... We Provide all kinds of accounts of all countries similar as USA, UK, Germany, and so on, at cheap rate. If you want to buy any accounts then visit our website. choose products and place your order and contact fast.

24 Hours Reply/Contact WhatsApp: +1 ‪(765) 422-5303‬ Telegram: – @wisbizs

Hi Jon, Thank you very much for the detailed information. However, I was wondering if you can provide information on how to make API calls to external systems that requires registration, in which the client has to make CSR request and in return the clients is provided with an SSL certificate and a private key. In Postman, you will need to add the cert and key then pass client ID and Client screen to obtain a token. I am using on-premise DB 21c XE and APEX 23.1. I added the cert to the wallet but could not add the key "Header not present in private key". As recommended by oracle support tired using openssl to combine the cert and key into a single .p12 file the imported the file into the wallet and still not working, receiving this error: ORA-29273: HTTP request failed ORA-06512: at "APEX_230100.WWV_FLOW_WEB_SERVICES", line 1325 ORA-06512: at "APEX_230100.WWV_FLOW_WEB_SERVICES", line 897 ORA-29024: Certificate validation failure. Here is a link to the oracle support article for refrence: support.oracle.com/epmos/faces/DocumentDisplay

Thank you

Hi Jon, please help me!. I need to transform this cURL en an APEX code: curl --location --request GET 'URL here' \ --header 'Content-Type: application/json' \ --data '{"params": {"token": "0b9d446691d649fb3078ed30a463de"}}'

I don't know how put 'data' in the call to apex_web_service. Thanks for you help in advance!

Isaac

Email: Danielmeuliweberecovery @ email . com Viber: + 39. 351. 201. 3528 Telegram: @ Danielmeuli

Using a professional crypto recovery service like Daniel Meuli Web Recovery offers several advantages. They have the expertise and specialized tools required to navigate the complexities of blockchain technology and trace lost crypto transactions. Their experience significantly increases the chances of successful recovery, saving you valuable time and effort. Determining the recoverability of lost crypto depends on various factors such as the nature of the loss, the time elapsed since the loss occurred, and the information available. Daniel Meuli Web Recovery offers a free initial assessment to evaluate the recoverability of your lost crypto and provide you with an informed recommendation. Daniel Meuli Web Recovery prioritizes the security and confidentiality of your personal information and crypto assets. They employ industry-standard encryption protocols and follow strict privacy policies to ensure that your data remains protected throughout the recovery process. While Daniel Meuli Web Recovery specializes in recovering lost crypto assets, they also offer guidance and recommendations on preventing future losses. They can provide advice on secure storage solutions, best practices for handling crypto assets, and implementing robust security measures to safeguard your investments. Remember, no one is immune to the risks associated with cryptocurrencies, but with the right knowledge and expert guidance from Daniel Meuli Web Recovery, you can navigate the treacherous waters of lost crypto and reclaim what's rightfully yours. Recovering lost cryptocurrency assets is an area in which Daniel Meuli Web Recovery is a reputable and knowledgeable supplier. What was once thought to be irretrievable has been recovered for numerous people and businesses thanks to their vast knowledge, cutting-edge procedures, and successful track record. Both individuals and companies may proactively safeguard their priceless cryptocurrency assets by realizing the significance of crypto recovery, recognizing the typical reasons why cryptocurrency is lost, and employing the services of a respectable company like Daniel Meuli Web Recovery. Daniel Meuli Web Recovery makes sure that everyone can access and feel protected in the world of cryptocurrency because to their dedication to security and client satisfaction. As the crypto world changes constantly, so too should your security protocols. To keep ahead of such dangers, Daniel Meuli Web Recovery suggests that you update and review your security protocols on a regular basis. While you cannot get out of this mess, call Daniel Meuli web recovery through Information above

Hi, Jon.

Thanks for this excellent article. i don´t know if I can do questions about this article, but... I have an Oracle Apex application in hosting in Oracle Cloud and I need to call Google Maps API services, but my problem is configuring the wallet. That for me is truly nightmare.

You know any article about to configure Google Maps services in Oracle Wallet OCI? Any help will be grateful.

Regards,

Jairo.