> 8.1.6 runtime libs, but I do have more recent if people think it will > help (8.1.7 is available) > > I'm actually running the query against a 9i database, but the host > it's running on is an old 2.6 box without 64 bit so getting 9i on > there will be problematic (it also has to connect to some 8.1.5, 8.1.6 > and 8.1.7 versions).
8.1.6 should be plenty new. Very odd. I copied your code exactly and it works. I'm in an all *nix environment though ... I see some threads in Google about having to change registry settings on Windows. But in all those cases they also say that ALTER SESSION will override. No privileges are supposed to be required either. ---- Steve Sapovits GSI Commerce http://wwww.gsicommerce.com [EMAIL PROTECTED]
