text: SET SERVEROUTPUT ON;
  
  DECLARE
   vCtr     Number;
   vSQL     VARCHAR2(1000); 
   vcurrSchema VARCHAR2(256);
  BEGIN
  
    SELECT sys_context( 'userenv', 'current_schema' ) into vcurrSchema from dual;
    dbms_output.put_line('Current Schema: '||vcurrSchema);
  
    SELECT COUNT(*)  
      INTO vCtr  
      FROM user_tables  
      WHERE table_name = 'STEPSTATUS';
   
    IF vCtr = 0 THEN
      dbms_output.put_line('Creating STEPSTATUS table');
      vSQL := 'CREATE TABLE STEPSTATUS
      (	
           id            NUMBER(19,0) PRIMARY KEY,
           obj           BLOB,
           CONSTRAINT STEPSTATUS_STEPEXEC_FK FOREIGN KEY (id) REFERENCES STEPEXECUTIONINSTANCEDATA (stepexecid) ON DELETE CASCADE
      )';  
     EXECUTE IMMEDIATE vSQL;   
    END IF;
  
  END;
  /
  