Modified DropSchemaCmd to use autocommitMode default of Stmt::executeQuery() and Stmt::executeNonQuery()

Renamed rdbms::AutocommitMode::ON and rdbms::AutocommitMode::OFF to rdbms::AutocommitMode::AUTOCOMMIT_ON and rdbms::AutocommitMode::OFF respectively

Done

Replaced oracle::occi::setVector(occiStmt.get(), 1, archiveFileIdList, SYS, ODCINUMBERLIST) with temporary table TEMP_TAPE_FILE_BATCH

Done

When dropping the database schema, tables and sequences are only
dropped if they are present.

This commit avoids the message "table or view does not exist" by
modifying cta-catalogue-schema-drop to simply not try to delete
tables that do not exist.

cta/CTA#87 cta-catalogue-delete-all-data and cta-catalogue-schema-drop should require interactive confirmation

Removed the now redundant locking commands for the catalogue schema.
These commands were made redundant when the cta-catalogue-schema-drop
command was made interactive.

cta/CTA#87 cta-catalogue-delete-all-data and cta-catalogue-schema-drop should require interactive confirmation

Made the cta-catalogue-schema-drop command interactive