How to Create Queues with DBMS_AQADM
Create a queue table and a queue for your own message type, start it, and stop enqueuing or dequeuing separately.
PLSQL
PL/SQL (Procedural Language for SQL) is Oracle's proprietary extension to standard SQL. It combines the data manipulation power of SQL with the procedural capabilities of a programming language. PL/SQL allows developers to write complex database-centric applications by incorporating variables, conditions, loops, error handling, and modular programming constructs like procedures and functions. This language is tightly integrated with Oracle databases, enabling efficient data processing and transaction management.
How to Use DBMS_JOB in Oracle (legacy jobs)
Maintain old code that uses DBMS_JOB, see how its jobs become Scheduler jobs, and map each call to DBMS_SCHEDULER.
How to Build Job Chains with DBMS_SCHEDULER
Run load, check, and report steps as one Scheduler job, with rules that start the next step on success or failure.
How to Handle Scheduler Job Failures in Oracle (job log, retries)
Find the error of a failed Scheduler job in the run log, and stop a job that keeps failing with the MAX_FAILURES attribute.
How to Create Scheduler Programs in Oracle (schedules, arguments)
Define what to run as a program with arguments and when as a named schedule, and combine them in jobs with argument values.
How to Write Scheduler Calendar Expressions in Oracle
Describe when Scheduler jobs repeat with FREQ, INTERVAL, and BY clauses, and test the run dates before you schedule anything.
How to Create Jobs with DBMS_SCHEDULER.CREATE_JOB
Schedule PL/SQL to run nightly with one call, run it on demand to test it, check its runs, and stop or drop jobs.
How to Store Credentials with DBMS_CREDENTIAL
Store user names and passwords in the database under a name, so PL/SQL code and jobs never contain the password itself.
How to Send E-mail with UTL_MAIL
Install UTL_MAIL and send e-mail from PL/SQL in one call, with copies, a MIME type, and a text or binary attachment.
How to Open TCP Connections with UTL_TCP
Connect to any host and port from PL/SQL, write and read text lines, and speak simple protocols such as HTTP by hand.
How to Call HTTPS Endpoints with UTL_HTTP.SET_WALLET
Trust HTTPS servers from PL/SQL with the operating system's certificate store or an Oracle wallet, set with SET_WALLET.
How to Send a POST Body with UTL_HTTP.WRITE_TEXT
Send JSON to a REST API with a POST request from PL/SQL, read the result, and handle requests the server rejects.
How to Read HTTP Responses with UTL_HTTP.BEGIN_REQUEST
Call web services with full control: request headers, status codes, response headers, bodies, authentication, and redirects.
How to Call a Web Page with UTL_HTTP.REQUEST
Send a GET request and get the response body in one call, from SQL or PL/SQL, and read JSON results in the same query.
How to Look Up Host Names with UTL_INADDR
Find the IP address of a host name, or the name of an address, as the database server resolves them.
How to Allow Network Access with DBMS_NETWORK_ACL_ADMIN
Allow a database user to reach specific hosts and ports for HTTP, connections, or name lookups, and fix ORA-24247.
How to Read a Text File Line by Line with UTL_FILE.GET_LINE
Read a text file on the database server one line at a time, detect the end of the file, and split CSV lines into fields.
How to Encode URLs with UTL_URL
Turn spaces, accented letters, and reserved characters into % codes for URLs and query values, and decode them again.