Peter,
I reconnected to the Oracle application to perform your suggestion and i found that your suggestion works. Moreover I found my initial attempt(select -seq_object_id.nextval from life311.fund) working too. Strange!
Thanks.
>>Hi All,
>>
>>I am using the DataExplorer Application to connect to an Oracle database. I want to select the sequence-value following the last sequence :
>>
>>select -seq_object_id.nextval from life311.fund
>>
>>
>>I get the following error: Microsoft OLE DB Provider for ODBC Drivers : [Microsoft][ODBC driver for Oracle][Oracle]ORA-02289: sequence does not exist
>>
>>When I perform the same action in TOAD, I don't get an error.
>>
>>Could someone help me with this?
>>
>>Thanks beforehand.
>
>How about:
select seq_object_id.nextval from life311.fund