sponsor Vim development Vim logo Vim Book Ad

viora.vim : Access Oracle from Vim

 script karma  Rating 4/1, Downloaded by 123  Comments, bugs, improvements  Vim wiki

created by
Andrey Voropaev
script type
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

rate this script Life Changing Helpful Unfulfilling 
script versions (upload new version)

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:

If you have questions or remarks about this site, visit the vimonline development pages. Please use this site responsibly.
Questions about Vim should go to the maillist. Help Bram help Uganda.