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

    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
    Croatia, Europe
    Provided Answers: 5
    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