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: cost management project oracle 10g any help?
Goto Forum:

Current Time: Mon Aug 21 12:43:18 CDT 2017

Total time taken to generate the page: 0.15507 seconds