sql_menu

Synopsis

A Perl script to emulate the functionality of Oracle's SQL*Menu program

Usage

perl sql_menu.pl

Description

Sql_menu.pl is a program that provides the same basic functionality as Oracle's (now defunct) SQL*Menu package. SQL*Menu is a hierarchical menuing system with security on a per-item basis.

Unlike SQL*Menu, sql_menu.pl does not show menu items that you don't have access to. If you can't do it, you can't see it. This does mean that item numbers will be a bit different.

This program really isn't VMS-specific, and should run on any system with the appropriate modules installed. You'll need to customize things, though, since this has been tweaked a bit for my local installation.

Limitations

• Help isn't currently implemented.
• Not all of SQL*Menu's functionality is implemented. More specifically, item code 6 (execute an SQL statement) is not available.
• Parameter substitution is only minimally implemented--just username and password
• Since we're not linked against SQL*Plus and Forms, item codes 4 and 5 do cause a sub-process to be created, while in SQL*Menu it probably just meant you'd call the linked-in program.

Author

Dan Sugalski

Requirements

DBI, DBD::Oracle, Curses, perlmenu, Perl 5.004 or higher