Hi,
I'm trying to get the next value from a sequence using SAPDB 7.3.29.
I'm connected with the Database Administrator account (dba).
First I tried:
select seq_typ_base.nextval from dual
and
select seq_typ_base.nextval from DUAL
I get an SQLException saying "Relation "dual" does not exist"
The same statement executed in SQL Studio logged in as dba works fine.
Then I tried:
select seq_typ_base.nextval from dba.dual
and
select seq_typ_base.nextval from sysdba.dual
and
select seq_typ_base.nextval from DBA.DUAL
and
select seq_typ_base.nextval from SYSDBA.DUAL
Last I tried:
select last_number from user_sequences where
sequence_name='seq_typ_base'
But I also get an error.
All other stuff like execute or update on my own tables works fine.
Please tell me how to access tables like "dual" with jdbc.
Thanks in advance and a happy new year.
MfG
Alexander Schulz
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
