Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    44

    Unanswered: Problem in passing the URL address to the procedure

    Hi everybody,
    I am calling a procedure from my package. My procedure takes URL address as input parameter. URL address has an ampersands (&) in between...so my procedure is not executing, it is expecting for the input.
    Can anyone help me out in this please....

    Thanks in Advance
    Mahesh

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    DEFINE

    Hi Mahesh

    The solution is to set the SQL*Plus DEFINE setting OFF or to another special character:

    [SYSTEM@DB1.ORA-0000.COM] SHOW DEFINE
    define "&" (hex 26)
    [SYSTEM@DB1.ORA-0000.COM] SET DEFINE OFF
    [SYSTEM@DB1.ORA-0000.COM] SHOW DEFINE
    define OFF
    [SYSTEM@DB1.ORA-0000.COM] SET DEFINE $
    [SYSTEM@DB1.ORA-0000.COM] SHOW DEFINE
    define "$" (hex 24)


    Hope this helps!


    REmi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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