ORA-01704: Stringconstante is to long.

[bartburg]

Hi

i want to use # CSVIdentityNameList ( ) # to get a list cognos specified groupnames so i can set the following

case when [xxx] in # CSVIdentityNameList ( ) #
then [name]
else null
end

when i try to do this i get error involving the string lenght.

is there a easy way to get only cognos specified groups for a cognos user?

we use single signon so i think iam getting the full ad list wich i dont want!

[Francis aka khayman]

not sure if this will work and this is a crude solution. to break the string in three parts using substring function

[bartburg]

Could you give me an example?