Forums Register Login

SQL error:java.sql.SQLException: ORA-01008: not all variables bound

+Pie Number of slices to send: Send
I'm getting ORA-01008 when I run the following INSERT
statement, product_id is a PK and a number column, as I am using
"setString" should this be a long when I INSERT?

I'm using Oracle 8.1

REG




[edited to remove whitespace from beginning of lines so page doesn't scroll right]
[ January 27, 2005: Message edited by: Jeanne Boyarsky ]
+Pie Number of slices to send: Send
Reggie,
It's better to use a long because it clearly expresses the intent of the setter and eliminates the possiblity of a database exception caused by an poorly formatted a string.
+Pie Number of slices to send: Send
You had 6 twice and didn't set something for 7.
cheers.
Police line, do not cross. Well, this tiny ad can go through:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 1883 times.
Similar Threads
Java Code does not recognize my sequence name
ORA-01008: not all variables bound
SQLException: ORA-01008
java.sql.SQLException: ORA-01008: not all variables bound
Help with: java.sql.SQLException: ORA-01008: not all variables bound
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 02:25:34.