Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    11

    Red face Unanswered: to pass multi values into single parameter ???

    Hey Gurus,

    Can you help me to pass multi values into single parameter in plsql.

    This is the scenario (a rough one ):

    create procedure abcd(p_single IN Varchar(100))
    select * from table_x
    where col_1 IN(p_single)


    for p_single I need to pass more than one string.

    Could you please help me ...?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    A varying IN list ... check the article on Tom Kyte's blog, or search for another resources by yourself (now you know what to search for).

Posting Permissions

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