Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with an update sentence within a stored procedure

 
Ilh Oleo
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The following example works on Oracle DB:

results:

---------------------------------------------------
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic