Home » SQL & PL/SQL » Client Tools » Substitution Variables (11g)
Substitution Variables [message #444511] Mon, 22 February 2010 05:27 Go to next message
eight8ball@gmail.com
Messages: 20
Registered: February 2010
Junior Member
Hi,

Can someone tell me how I go about writing a query that doesnt see the '&' symbol as a substition character. The problem I have is:

         
      select replace
                   ( fnd_profile.value( 'XXBPO_URL')   
                   , '&DOCID'             
                   , ai_dfv.bpo__document_link
                   )  document_link
        from ap_invoices_all     ai
           , ap_invoices_all_dfv ai_dfv
       where 1=1
           -- where clause  


The problem above is that instead of replacing the characters &DOCID with the required value, it is prompting for input.

Thanks
Joe
Re: Substitution Variables [message #444513 is a reply to message #444511] Mon, 22 February 2010 05:29 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
set define off
Re: Substitution Variables [message #444516 is a reply to message #444511] Mon, 22 February 2010 05:44 Go to previous messageGo to next message
eight8ball@gmail.com
Messages: 20
Registered: February 2010
Junior Member
and if you use toad?
Re: Substitution Variables [message #444517 is a reply to message #444511] Mon, 22 February 2010 05:46 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
It has an equivalent setting but I can't remember what it is off the top of my head - have a look under preferences/options
Re: Substitution Variables [message #448043 is a reply to message #444517] Fri, 19 March 2010 03:36 Go to previous message
n_prabhakar
Messages: 3
Registered: March 2010
Location: Singapore
Junior Member
Got this from where. pls try this

* Right click in the editor and uncheck the "Prompt for substitution variables" option.

* Menu view-->toad options: go to the "execute/compile" node and uncheck the "Prompt for substitution variables" option.
Previous Topic: Setting LINESIZE
Next Topic: different charactersets show line-break in select result
Goto Forum:
  


Current Time: Thu Sep 29 02:13:23 CDT 2016

Total time taken to generate the page: 0.12988 seconds