Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    5

    Unanswered: Associative array

    I have a variable declared as this:
    type ltype_Queue is table of NUMBER index by binary_integer;
    l_Queue ltype_Queue;


    How can I accomplish the equivalent to this:

    select *
    from Items
    where ID in l_Queue


    Thanks,
    Layne

  2. #2
    Join Date
    May 2003
    Posts
    87

    Re: Associative array

    select *
    from Items
    where ID in (select * from TABLE(cast(l_Queue as myTableType)));

    where myTableType is a data type defined as below :
    create type myTableType as table of varchar2(255)
    /


    Originally posted by lrobin3
    I have a variable declared as this:
    type ltype_Queue is table of NUMBER index by binary_integer;
    l_Queue ltype_Queue;


    How can I accomplish the equivalent to this:

    select *
    from Items
    where ID in l_Queue


    Thanks,
    Layne

Posting Permissions

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