oracle_preview_sql

oraclecompileobject with warnings=true

oraclecreateorreplace

oracleconnectioninfo

Compatibility wrapper for one DDL statement; preview by default, execution reuses the same DDL profile gate and confirmation

oraclesetsessionlevel with action=drop; immediately returns the session to READONLY

oraclesetsessionlevel with level=READWRITE; preview is still the default

Compatibility wrapper around oracleexecute; token-only calls work for five minutes after previewsql/oraclepreviewsql in the same server process, DML rolls back when commit is omitted, and durable commit requires explicit commit=true; non-transactional effects still consume confirmation even when rol

oracleschemainspect

Zero-arg discovery: tools, operating level, feature tiers

Compile errors for the current schema, an owner, or one PL/SQL object

Preview or compile one PL/SQL/view object through the DDL profile gate; execution requires the single-use confirmation grant returned by preview

Describe the active profile and redacted connection posture; if live metadata is unavailable, returns connected=false with a structured connectionerror and nextactions

Preview or apply one CREATE OR REPLACE statement through the classifier and DDL profile gate

Column and constraint metadata for a table or view

Index metadata, indexed columns, and function-based expressions

Trigger timing, target table, status, and body

View definition metadata and columns

Execute one non-read statement through the active profile/session gate; DML rolls back by default, while commits, DDL/Admin, and non-transactional effects such as sequence NEXTVAL require the execution grant from oraclepreviewsql; query-shaped NEXTVAL is refused because this path does not fetch rows

Diagnostic EXPLAIN PLAN for a vetted read-only statement; writes PLANTABLE and requires READWRITE plus allowplantablewrite=true

DBMSMETADATA DDL for an object

Full source text or an inclusive fromline/toline range for a package, procedure, function, trigger, or type; pair the range with a line returned by oraclesearchsource; omit objecttype to return every visible source variant for the object name

List configured connection profiles without exposing connect strings, usernames, or credential references

List schemas that own objects visible to this session

Preview or apply an exact oldtext→newtext patch to one stored PL/SQL source object (package/body/type/view) through the classifier and DDL profile gate; TOCTOU-safe, re-fetching the current source and re-confirming at execute time

Read PL/Scope identifiers/statements for one object and report unused declarations plus dynamic-SQL lines when metadata is populated

Run a read-only SELECT/WITH (paginated, parameter-bound)

Read one capped CLOB/NCLOB/text value by key

Safely sample the first rows of a table or view

List objects in the current schema, one owner, or all accessible schemas

Search ALLSOURCE for a needle; optionally use owner="", objecttype, and namelike to widen or narrow scope; matching lines are capped by maxlinechars, and their LINE values can be passed to oraclegetsource's fromline/toline range

Preview/apply a temporary session operating-level elevation within the profile ceiling, or drop back to READONLY

Reconnect the server to another configured profile

oraclepatchsource for a package spec or body

oraclepatchsource for a view

oraclepreviewsql

oraclequery

Compatibility helper that lists or reads the last in-process source-patch preview created by oraclepatchsource, patchpackage, or patchview

oracleswitchprofile (db is accepted as an alias for profile)