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.