Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataExplorer and Oracle query select on sequence error
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
DataExplorer and Oracle query select on sequence error
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01052728
Message ID:
01052728
Views:
69
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.
Zakaria al Azhar
My blog on Actuaris.net
Next
Reply
Map
View

Click here to load this message in the networking platform