Hello Maurizio,

>i tried something like
>Update myTable set :myfield = .......
>
>... where myfield is a parameter of the procedure ,
>but it doesn't work ,
>is it possible to use a parameter as a a field name ?

Parameters only work for -values- not for anything else.

If you want to make a dynamic SQL statement, take a look
at the EXECUTE STATEMENT statement in the Docs
folder.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com