Samples for stored procedures
-----------------------------

        Before running samples you must create tables:

    X:\>inl -u SYSTEM/MANAGER -f cretab.sql

        Procedure creation:

    X:\>inl -u SYSTEM/MANAGER

     SQL> create proc <file>
          <file> - file that contains procedure text.

        Procedure result will be inserted into table called "RESULTS".

initres.sql - Procedure init_results creates table "RESULTS".

insres.sql  - Procedure ins_result inserts record into "RESULTS"
              (according to parameter).

sample.sql  - Procedure sample. Various operations with database
              (including transactions).

tparam.sql  - Procedure parameters. Passes input parameters that has been
              sent by EXECUTE operator.

updtab.sql  - Procedure updtab.sql performs positional update 
              (WHERE CURRENT OF ...). Must be called as updtab('tab2','i','j').

retcur.sql  - Procedure retcur returns a cursor.

tretcur.sql - Procedure testretcur uses the result returned by "retcur" and 
              performs positional update.

thread1.sql
thread2.sql - 2 simple identical procedures.
              Both thread1 and thread2 must be run.
              Result must be the following:
                  Procedure1
                  Procedure2
                  Procedure1
                  Procedure2
                  ...


blobt.sql   - Procedure blobtest performs different operations on the table  
              containing BLOB column. 
