Capture screenshots in PL/SQL
Add screenshot and scrolling GIF capabilities to your Oracle PL/SQL applications with UTL_HTTP. Database-native, no external infrastructure needed.
Installation
- 1Ensure UTL_HTTP is available (standard in Oracle Database)
- 2Configure ACL for external network access
- 3Get your API key from the dashboard
Authentication
Include your API key in the X-KEY header with every request:
DECLARE l_http_request UTL_HTTP.req; l_http_response UTL_HTTP.resp; BEGIN l_http_request := UTL_HTTP.begin_request(l_url); UTL_HTTP.set_header(l_http_request, 'X-KEY', 'your-api-key'); l_http_response := UTL_HTTP.get_response(l_http_request); END;
PL/SQL Screenshot Example
Capture a screenshot or create a scrolling GIF animation with a simple GET request:
DECLARE
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
l_blob BLOB;
BEGIN
l_http_request := UTL_HTTP.begin_request(
'https://api.scrnpix.com/screenshot?url=https%3A%2F%2Fexample.com&width=1280&height=720&format=png');
UTL_HTTP.set_header(l_http_request, 'X-KEY', 'your-api-key');
l_http_response := UTL_HTTP.get_response(l_http_request);
-- Read response into l_blob
UTL_HTTP.end_response(l_http_response);
END;DECLARE
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
l_blob BLOB;
BEGIN
l_http_request := UTL_HTTP.begin_request(
'https://api.scrnpix.com/animate?url=https%3A%2F%2Fexample.com&scroll_duration=3000&scroll_easing=ease-in-out');
UTL_HTTP.set_header(l_http_request, 'X-KEY', 'your-api-key');
l_http_response := UTL_HTTP.get_response(l_http_request);
-- Read response into l_blob
UTL_HTTP.end_response(l_http_response);
END;Response Format
On success, the API returns the image binary data directly in the response body.
| Status Code | 200 OK |
| Content-Type | image/png, image/jpeg, or image/gif |
| Body | Binary image data (BLOB) |
| Error Response | Error message with 4xx/5xx status |
Key Features
Zero Setup
UTL_HTTP is built into Oracle Database. Just configure ACL for external access.
Production Ready
Built on Cloudflare Workers with global edge network. Handles concurrency and browser lifecycle automatically.
PL/SQL Integration
Native database integration. Works with Oracle APEX, Forms, Reports, or any PL/SQL environment.
Rich Features
Custom viewport sizes, full page capture, PNG/JPEG formats, scrolling GIFs with 15 easing functions.
Frequently Asked Questions
Do I need to install anything in Oracle Database?
No. UTL_HTTP is built-in. Just configure network ACLs to allow external HTTPS connections.
Can I use this with Oracle APEX?
Yes. Scrnpix works with any Oracle environment — APEX, PL/SQL procedures, Oracle Forms, or database jobs.
How do I store the screenshot in the database?
Read the response body into a BLOB column. Use UTL_HTTP.read_raw in a loop to capture binary data.
What Oracle version is required?
Oracle 10g+ with UTL_HTTP and network ACL support. The API is a simple HTTP GET request.
Ready to capture screenshots in PL/SQL?
Get your API key and start rendering screenshots in seconds. Free tier includes 50 screenshots per month.
Start Free