Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: How to ignore variables substitution

    I have a lot of inserts statemens with html code inside them.
    I.E.:
    insert into STEP_CTRL_ACTIV_EVIDENCE_L (ID,STEP_CTRL_ACTIV_EVIDENCE,EVIDENCE,LANG,LAST_UP DATE,USERID) values ('1','1','<P>&nbsp;</P>','1',to_timestamp('2004-10-11 15:57:40', 'YYYY-MM-DD HH24:MIS'),'15');

    When I try to execute it, at "&nbsp;" it shows an input box where I should replace that 'variable' with a value.
    But it isn't a varible.
    It doesn't work with Toad neither SQL Plus.

    How can I do to ignore them?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    yes,
    replace & with \& it should work in TOAD

    Code:
    insert into STEP_CTRL_ACTIV_EVIDENCE_L
    (ID,STEP_CTRL_ACTIV_EVIDENCE,EVIDENCE,LANG,LAST_UP DATE,USERID)
    values ('1','1','<P>\&nbsp;</P>','1',to_timestamp('2004-10-11 15:57:40', 'YYYY-MM-DD HH24:MI:SS'),'15');
    Last edited by madafaka; 10-27-05 at 11:25.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    or execute

    Code:
    set define off
    before you run this statement

    -cf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •