Re: sequences, Ole and "invalid table name"

> If so, one could one be lucky by wrapping the select nextval in a
> function and selection that from dual?

Tried that, after a few attempts it seems that I also can't call a function via OleDb which at least adds more info to the problem. I saw this on a web site

"Oracle Provider for OLE DB allows consumers to execute a PL/SQL stored procedure with an argument of REF CURSOR type or a stored function returning a REF CURSOR"

Now the obvious interpretation of that is that my function needs to return a ref cursor which it doesn't, but I'm a novice and its late and I'm sleepy so I'm going to find out how to do that tomorrow :-) Received on Fri Jul 20 2007 - 16:26:10 CDT