Creating and Running PL/SQL Blocks Within ttIsql

You can create and run PL/SQL blocks from the ttIsql command line.

Set serveroutput on to display results generated from the PL/SQL block:

set serveroutput on

Create an anonymous block that puts a text line in the output buffer. Note that the block must be terminated with a slash (/).

Command> BEGIN
DBMS_OUTPUT.put_line('Welcome!');
END;
/
Welcome!
PL/SQL procedure successfully completed.
Command>

See PL/SQL Blocks in the Oracle TimesTen In-Memory Database PL/SQL Developer's Guide. For information on error handling in ttIsql for PL/SQL objects, see Showing Errors in ttIsql in the Oracle TimesTen In-Memory Database PL/SQL Developer's Guide.