Executing PL/SQL blocks
One of the powerful features of an Oracle database is PL/SQL. By using OraLib, you can execute PL/SQL blocks, pass input parameters, and receive output parameters. Output parameters can even be resultsets (cursor in Oracle docs). The following example will execute two SQL select statements and fetch rows by using cursor-named variables: