Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Help with an update sentence within a stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help with an update sentence within a stored procedure" Watch "Help with an update sentence within a stored procedure" New topic
Author

Help with an update sentence within a stored procedure

Ilh Oleo
Ranch Hand

Joined: Feb 07, 2007
Posts: 57
Hi to all!

I'm trying to automatize some data cleaning through a stored procedure but i'm gettting an error message.
What i want to do is pass a value that is the name column from my table to the stored procedure and so i can pass any column name but like i still don't understand very well how to define a stored procedure i'm havinf some troubles.

For example if i type this:
CALL limpia('column_name')
I get this error:
Unknown column 'TIPO_EDUCA' in 'field list



Could someone help me,please?
Ilh Oleo
Ranch Hand

Joined: Feb 07, 2007
Posts: 57
Someone in another forum recommended me to use prepared statements but i don't sure how to call it.
I did something like this:


Does anybody know how should i execute my procedure?
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
The following example works on Oracle DB:

results:

---------------------------------------------------
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help with an update sentence within a stored procedure