Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Unhappy Unanswered: IN list returned by a function

    I am trying to do the following with no success (ORACLE 9i, through SQLNavigator4):

    FUNCTION GET_LIST RETURN VARCHAR2 IS
    BEGIN
    return '''GLOBAL_ID1'',''GLOBAL_ID2''';
    END GET_LIST;

    then I have a SQL query, which I type right in SQL Navigator, that does the following:

    select * form my_table where id in (my_package.get_list())

    if my function returns only one value, the query works, the moment I return a comma-delimited string, it stops working. How can I fix it?

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Does this realy work ?

    Hello,

    i have never seen such syntax in PL/SQL. Are you sure that you can return a list of VARCHAR2 in a function in this way ?
    If you want to return array or list of characters, I normaly use collection types or REF cursor ?!!?!

    By the way, it is not a bug of your SQL Navigator ...

    Best regards
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

Posting Permissions

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