message: ORA: Add simple query block parse
diff: @@ -6,6 +6,7 @@ import queries from './queries';
  import OracleDBLib from 'oracledb';
  import GenericDialect from '../generic';
  import { DatabaseInterface } from '@sqltools/core/plugin-api';
  +import { trim, pipe, trimCharsEnd } from 'lodash/fp';
  const OracleDBLibVersion = '3.1.1';
  export default class OracleDB extends GenericDialect<OracleDBLib.IConnection> implements ConnectionDialect {
  @@ -70,12 +71,26 @@ export default class OracleDB extends GenericDialect<OracleDBLib.IConnection> im
  this.unregisterPool();
  }
  + public simpleParse(code) {
  + // Trim empties and slash (/) from code if it exists
  + code = pipe(
  + trim,
  + trimCharsEnd("/"),
  + trim
  + )(code);
  +
  + // Trim semicolon (;) if it doesn't end with "END;" or "END <name>; etc"
  + if (!/END(\s\w*)*;$/gi.test(code)) {
  + code = trimCharsEnd(";")(code);
  + }
  + return code;
  + }
  +
  public async query(query: string): Promise<DatabaseInterface.QueryResults[]> {
  const conn = await this.open();
  - const queries = query.split(/\s*;\s*(?=([^']*'[^']*')*[^']*$)/g).filter(Boolean);
  + const q = this.simpleParse(query);
  const results: DatabaseInterface.QueryResults[] = [];
  try {
  - for(let q of queries) {
  let res = await conn.execute(q, [], { outFormat: this.lib.OBJECT });
  const messages = [];
  if (res.rowsAffected) {
  @@ -85,10 +100,10 @@ export default class OracleDB extends GenericDialect<OracleDBLib.IConnection> im
  connId: this.getId(),
  cols: (res.rows && res.rows.length) > 0 ? Object.keys(res.rows[0]) : [],
  messages,
  - query: queries[results.length],
  + query: q,
  results: res.rows,
  });
  - }
  +
  } finally {
  if (conn) {
  try {
  