Inserts on a table with few indexes and no referencial integrity constraints are done very fast on oracle, so a stored procedure will not be such a big performance benefit. Oracle caches sql statements, so your prepared insert statement (if you are using placeholders) will be read from cache and not even compiled again.

My guess is that you will see a performance decrease if you put the sql command in a string and executes it direct without using placeholders, but only a small one.

I usually use stored procedures (for inserts) to create a interface layer for the database users, hiding the physical table design from them. This way I can change the physical tables without needing to rewrite any application code. So I advocate the use of stored procs for everything (except building portable applications :)



/brother t0mas