Home » SQL & PL/SQL » SQL & PL/SQL » Sequence numbers in SQL or Stored Procedure
Sequence numbers in SQL or Stored Procedure [message #37917] Wed, 06 March 2002 05:00 Go to next message
uma
Messages: 67
Registered: May 2001
Member
I like to see sequence numbers in my written SQL or my stored procedure whenever I have some problem in execution. Some times in execution it is giving error saying 1333 line has a problem. But how to assign sequence numbers for SQL code?

Thanks in Advance,

Uma
Re: Sequence numbers in SQL or Stored Procedure [message #37918 is a reply to message #37917] Wed, 06 March 2002 05:45 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
what is exactly the error is ?

the correct us is sequence_name.nextval and sequence_name.currval
Previous Topic: ORA-00903
Next Topic: Create table from existing table
Goto Forum:
  


Current Time: Fri Mar 29 10:47:32 CDT 2024