• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Customize input message - PL/SQL Substitution variable

 
Kasi Viswan
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic