OraFAQ Forum: Client Tools » Substitution Variables

Home » Other » Client Tools » Substitution Variables (11g)

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

Substitution Variables [message #444511]

Mon, 22 February 2010 05:27

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

Report message to a moderator

Re: Substitution Variables [message #444513 is a reply to message #444511]

Mon, 22 February 2010 05:29

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

set define off

Report message to a moderator

Re: Substitution Variables [message #444516 is a reply to message #444511]

Mon, 22 February 2010 05:44

eight8ball@gmail.com
Messages: 20
Registered: February 2010

Junior Member

and if you use toad?

Report message to a moderator

Re: Substitution Variables [message #444517 is a reply to message #444511]

Mon, 22 February 2010 05:46

cookiemonster
Messages: 13920
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

Report message to a moderator

Re: Substitution Variables [message #448043 is a reply to message #444517]

Fri, 19 March 2010 03:36

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.

Report message to a moderator

Previous Topic:	Setting LINESIZE
Next Topic:	different charactersets show line-break in select result

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 08:13:23 CDT 2024