Help with Oracle 7 menus

Hello,

I am an Oracle novice and I have purchased several books, which seem to be of limited help. I have a question that hopefully someone on the net can assist me with.

I am defining an Oracle menu. On selection of the first menu item I wish to execute an SQL statement. In the command type I placed 5 which is the type for SQLPLUS. In the command line I enter a select statement. When I execute the application I get an error of the form

SQLPLUS [usage] [options] etc. which gets repeated several times.

On the other hand if I use command type 2 and enter an os statement in the command line window, the os command executes perfectly fine.

When I enter 1 as a command type (menu) and type a menu name in the command line the menu does not appear.

ANy help will be greatly appreciated.

Jonathan Graham Received on Sat Apr 06 1996 - 00:00:00 CEST