Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Standard PL/SQL API Caching Error
We use SOA to expose a PL/SQL procedure as a REST API and post requests to it. This procedure utilizes standard PL/SQL APIs to create and update Person and Assignment records.
During debugging, we do not encounter any "single-row subquery returns more than one row" errors within the custom PL/SQL procedure. However, this error occasionally occurs during execution. Restarting (bouncing) the server resolves the issue temporarily.
Error Codes
---------------------------------------------------
ORA-01427
Tagged:
0