Re: sequences, Ole and "invalid table name"

On Fri, 20 Jul 2007 14:26:10 -0700, codefragment_at_googlemail.com wrote:

>> 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 :-)

Please have a look at
http://www.oracle.com/technology/sample_code/tech/windows/ole_db/index.html

Please also note the Oledb Tutorial on the right side of that page.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA