A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
Before insert Trigger
Joined: Apr 04, 2006
May 12, 2006 09:02:00
I have a table that has a before insert trigger. The trigger stores a value from another table in the first column. I include values for all columns minus the first one for my sql insert.
I get the error:
: Missing IN or OUT parameter at index:: 1
I think it means I need to include one more column for the insert. How do I do it for the first column with trigger?
fields = new String;
int i = 1;
sql = "INSERT into TBL_LOGS VALUES(?,?,?,?,?,?,?,?)";
ps = connection.prepareStatement(sql);
int rs = ps.executeUpdate();
I agree. Here's the link:
- it saves me about five hours per week
subject: Before insert Trigger
Auto Increment ID Field Table in the Oracle Database
how to insert 2 values togther in db?
How Do I Insert .... ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013