Thanx.......it's working now...... -wilson "Lageson, Tom" wrote: > Wilson, > Sequence.nextval is an oracle statement. It needs to be used in a SQL > statement. Simply put it in your insert statement such as > insert into temp values(sequence.nextval,'data','data','data'); > > - Tom > > > ---------- > > From: Wilson. P[SMTP:[EMAIL PROTECTED]] > > Reply To: A mailing list for discussion about Sun Microsystem's Java > > Servlet API Technology. > > Sent: Tuesday, July 13, 1999 4:13 AM > > To: [EMAIL PROTECTED] > > Subject: How to set the sequence number thru JDBC? > > > > <<File: wilsonp.vcf>> > > Hi > > > > I'm using prepared statement for insertion. Now, I would like to insert > > the next sequence value to the colulmn.How to do that? > > > > Ex: InsertTemp.SetInt(1,sequence.nextval); > > > > But, this is not working. > > > > - wilson > > > > > > > > > > -- > > > > > > > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html --
begin:vcard n:;Wilson tel;work:5595740 Extn:224 x-mozilla-html:FALSE org:Raffles Software Pvt.Ltd. version:2.1 email;internet:[EMAIL PROTECTED] title:Associate Systems Engineer note:www.raffles-software.com adr;quoted-printable:;;#121, 7th Floor,'The Estate'=0D=0ADickenson Road;Bangalore ;Karnataka;560042;INDIA x-mozilla-cpt:;-1 fn:Wilson .P end:vcard
