Results 1 to 2 of 2

Thread: Arrays

  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Angry Unanswered: Arrays

    Hi

    I am passing a string of numbers to a proc/function and running some dynamic sql: -

    e.g.
    myStr := '1,2,66,99';
    sql := 'select * from tbl where abc in ' || myStr;

    How can I pass myStr as an array or table so that I can bind the variable?

    cheers

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Follow this link: Ask Tom

Posting Permissions

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