[confused_too]

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?

[alligatorsql.com]

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