[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] DUAL table: String2Em: String to DecimalObject Conversion Error
Why not wrap id_seq.nextval in the same function? Though in some ways it
might cleaner to use a PL/SQL function wrapped around it, and called
from within a BEGIN-SQL block.
SQL> select to_char(bogo_seq.nextval) from dual;
TO_CHAR(BOGO_SEQ.NEXTVAL)
----------------------------------------
1
SQL> /
TO_CHAR(BOGO_SEQ.NEXTVAL)
----------------------------------------
2
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users