Now that we understand how SQL*Plus variables are stored, let's examine a real-world example. Here's an example from a STATSPACK report that reports on table growth as a function of the block size ...

Any return code or message that is generated by the DBMS is available in the macro variables SQLXRC and SQLXMSG after the statement executes. See SQL Procedure Pass-Through Facility Return Codes for ...