loss of performance when using anonymous pl/sql blocks?!

From: Markus Breuer <markus.breuer_at_gmx.de>
Date: Wed, 15 Oct 2003 14:00:47 +0200
Message-ID: <3F8D36EF.4090309_at_gmx.de>

Instead of using a set of different sql-statements i have decided to use an single, anonymous pl/sql block with host-variables. For example:

  cmp NUMBER := :hostvariable;
    UPDATE t_sample SET c_id=0 WHERE tid>cmp; END;
Are there any disadvantages concerning simle update-statement? Won't oracle cache such blocks, do they need more processing time or more cpu-power on the server? Or does oracle treat them as any other sql statement?

thx, markus Received on Wed Oct 15 2003 - 14:00:47 CEST

Original text of this message