>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!
And strange it is. What is that minus sign doing there?
>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
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
