Home » Developer & Programmer » Designer » Prompting the end user for a selection
Prompting the end user for a selection [message #160436] Sat, 25 February 2006 19:24
Messages: 1
Registered: February 2006
Junior Member
I am trying to prompt the end user for a selection after displaying a menu. The menu is designed in a procedure, displaymenu(), and when called executes as planned.

After displaying the menu, I need the end-user to make a selection based on this menu, however I can not create a procedure to "prompt and accept" input!

Using substitue variables will not work because I need the menu to display first, and I have tried repeatedly to somehow work it with accept and prompt, however that won't work because they are sql commands not pl/sql commands, and can't go inside the block.

Can anyone enlighten me on a work-around for this problem?
I would greatly appreciate it!

[Updated on: Sat, 25 February 2006 19:50]

Report message to a moderator

Previous Topic: After generating table API and insert data get trigger failure on first insert
Next Topic: pls.i want oracle designer software atleast trail version
Goto Forum:

Current Time: Thu Mar 23 19:20:06 CDT 2023