Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Location
    India
    Posts
    217

    Unanswered: comma separetad parameter to a SP

    I have a procedure which accepts a single input parameter which is varchar2.
    My input parameter looks like,

    Code:
    'a','b','c','d'
    How can i pass the whole thing as a SINGLE parameter?

  2. #2
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    try:
    Code:
    '\'a\',\'b\',\'c\',\'d\''
    or
    Code:
    '''a'',''b'',''c'',''d'''
    Last edited by madafaka; 11-02-05 at 07:28.

  3. #3
    Join Date
    Feb 2005
    Location
    India
    Posts
    217
    Thank you!
    The second one worked. I am facing some problem with the first one. Any how i will use the second one...

  4. #4
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    I wasn't sure which one is correct and I couldn't test it as I'm not connected to DB, so I posted both of them. Now I know first one is wrong :-)

  5. #5
    Join Date
    Feb 2005
    Location
    India
    Posts
    217
    I don't think '\' is the escape character for pl/sql. I have seen it in other langauges. Thanks any way.

Posting Permissions

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