Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Oracle/OAS and the fly likes Customize input message - PL/SQL Substitution variable Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Customize input message - PL/SQL Substitution variable" Watch "Customize input message - PL/SQL Substitution variable" New topic
Author

Customize input message - PL/SQL Substitution variable

Kasi Viswan
Ranch Hand

Joined: Sep 27, 2008
Posts: 42
Hi,

Am trying to make user input URL through substitution variable, am not able to use accept command since i am using pl/sql anonymous block and this statement is one of many in that block.
I want this message be displayed to the user, Enter value for :
am not able to use a substitution variable like this

Has anyone come across such issue?, your help is greatly appreciated.

i don't know why i get the smileys, its serverurl followed by : followed by portno

Thanks,
Kasi

[ November 02, 2008: Message edited by: Kasi Viswan ]

[ November 02, 2008: Message edited by: Kasi Viswan ]
[ November 02, 2008: Message edited by: Kasi Viswan ]
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1134

Kasi,
You said:

i don't know why i get the smileys

When posting to the forum, look for the "Disable smilies in this post" check box and make sure it is checked.

Good Luck,
Avi.
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Originally posted by Kasi Viswan:
[QB]Hi,

Am trying to make user input URL through substitution variable, am not able to use accept command since i am using pl/sql anonymous block and this statement is one of many in that block.
I want this message be displayed to the user, Enter value for :
am not able to use a substitution variable like this

Has anyone come across such issue?, your help is greatly appreciated.

i don't know why i get the smileys, its serverurl followed by : followed by portno

Thanks,
Kasi
QB]


Substitution variables are a feature of SQLPlus... is that what you're using? Could you post your pl/sql (between code tags)?
Kasi Viswan
Ranch Hand

Joined: Sep 27, 2008
Posts: 42
Hi, here is the part of my script, here instead of using a substitution variable &URL_AND_PORTNUMBER, i want some thing like &serverurl:portnumber

so a user will be prompted to, Enter the value for serverurl:portnumber.

Thanks for the inputs on disabling the smiley.


[ November 03, 2008: Message edited by: Kasi Viswan ]
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Kasi,

Accept & Prompt are SQLPlus commands. Annonymous blocks do support variable substitution via these commands (your substitution code looks correct and you did set severoutput on ). Are the Accept and Prompt part of the same Batch Script you are running in SQLPlus? They need to be part of the same session and you can't do this substitution outside of SQLPlus... if you need to do it external from SQLPlus you can do things like read a table that captures the information or something similar.

Paul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Customize input message - PL/SQL Substitution variable