OraFAQ Forum: SQL & PL/SQL » PlSql Command that display message and get a value from user with in a PLSQL Block

Home » SQL & PL/SQL » SQL & PL/SQL » PlSql Command that display message and get a value from user with in a PLSQL Block (Oracle Developer, Forms 6i, Windows Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PlSql Command that display message and get a value from user with in a PLSQL Block [message #551660]

Fri, 20 April 2012 01:00

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Hi,

I need to know a plsql command that can display a custome message and also gets a value from the user with in a procedure.

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551663 is a reply to message #551660]

Fri, 20 April 2012 01:04

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

DBMS_OUTPUT.PUT_LINE is capable of displaying a message. This is mostly useless as no end-user will ever see it (unless your users run procedures in SQL*Plus, for example). Therefore, consider use of OUT parameters.

Value can be passed from a user to a procedure through procedure's IN parameter(s).

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551666 is a reply to message #551660]

Fri, 20 April 2012 01:10

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In short, PL/SQL runs on the server and get input from its call and returns its output at the same time than it gives back the control to the caller.
Even dbms_output works in the same way, you get the content of dbms_output buffer AFTER you get back the control (but using dbms_output.get% procedure or implicitly with SQL*Plus).

The built-in only way to get intermediate result is table/pipelined function (and dbms_debug but this another story).
You can also read and write through pipes using dbms_pipe package; a PL/SQL procedure can read input parameters from a pipe and write its ouput into another one.

Regards
Michel

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551671 is a reply to message #551666]

Fri, 20 April 2012 01:28

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Guys thanks for quick response. My issue is I need a database stored procedure that when executed ask user for few information and then insert that data in a table.

So I need a command that can display my custom message and at the same time takes some data from user as input.

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551674 is a reply to message #551671]

Fri, 20 April 2012 01:37

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing built-in, you have to create it, for instance using dbms_pipe.

Regards
Michel

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551677 is a reply to message #551674]

Fri, 20 April 2012 01:41

azamkhan
Messages: 557
Registered: August 2005

Senior Member

ok is there a builtin that take user input like DBMS builtin

Report message to a moderator

Re: PlSql Command that display message and get a value from user with in a PLSQL Block [message #551686 is a reply to message #551677]

Fri, 20 April 2012 02:00

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No (third time).

Regards
Michel

Report message to a moderator

Previous Topic:	problem in subquery
Next Topic:	Calling a Web Service with SSL (working on a WCF SOAP webservice)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 03 06:53:12 CDT 2025