Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    50

    Unanswered: Problem in storing URL

    Hi!

    I try to store this URL in a VARCHAR field

    Code:
    INSERT INTO soldby VALUES ('OK Computer', 1997, 'Virgin', 'http://www.virginmegastores.co.uk/pws/ViewObject.vms?origin=pwssearchresult.jsp&event=link(pwsviewobject)&ot=review&ps_euk=298921');
    but it asks me to introduce the substitution variables for event, ot and ps_euk, wich are present in the URL. I just want to store the URL text as it is.

    Any explanation/suggestion?


    Thanks for your attention!
    Ah! Não ser eu toda a gente e toda a parte!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Problem in storing URL

    This is SQL Plus interfering. To stop it do this first:

    SQL> SET SCAN OFF

  3. #3
    Join Date
    Dec 2003
    Posts
    50

    Smile

    Thanks a lot for your prompt help, as usual!
    Ah! Não ser eu toda a gente e toda a parte!

Posting Permissions

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