created by

Andrey Voropaev

script type

utility

description

This script shall be used when one writes PL/SQL for Oracle in vim and wants to have quick and convenient way to test things out, or simply see results of queries. It takes queries directly from buffer. One can configure delimiters for that. Results are shown in separate buffer. In case of error, the script attempts to position cursor to the first error. For PL/SQL Quickfix mode is used, to mark positions of all errors.

install details

Unpack archive into your .vim directory. Start vim and run :helptags ALL to update tags file for help. The module is written in perl, so this interpreter should be compiled into vim. Also one should have perl modules DBI and DBD::Oracle installed. After installation, run :h viora to see all details about usage and configuration

Click on the package to download.

package	script version	date	Vim version	user	release notes
viora-4.tar.bz2	4	2021-10-21	7.0	Andrey Voropaev	Fixed problem with recognizing query on the very first line of buffer Fixed searching for error position if perl variables are in use in query
viora-3.tar.bz2	3	2021-09-23	7.0	Andrey Voropaev	Added check for validity of DB connection Fixed problem with query as last line in the buffer
viora.tar.bz2	2.0	2021-09-14	7.0	Andrey Voropaev	Added support for perl variables in SQL. Also number of affected rows is reported, where available. It is not available for SELECT!
viora.tar.bz2	1.0	2021-07-23	7.0	Andrey Voropaev	Initial upload

ip used for rating: 3.141.47.84