Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataExplorer and Oracle query select on sequence error
Message
From
24/09/2005 13:22:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01052728
Message ID:
01052731
Views:
6
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform