Dynamic SQL performance

From: <lalaina_at_my-dejanews.com>
Date: Fri, 21 Aug 1998 10:21:29 GMT
Message-ID: <6rjhn8$uh5$1@nnrp1.dejanews.com>

Hello Oracle users ,

I was wondering about the performance of DBMS_SQL package. My application starts by truncating a set of tables.

What is best in terms of perfomance :
SQL> @ file_with_truncate_statements.sql

or create a procedure using DBMS_SQL ?

Within our team, views are divergent on the topic. Could you help us ?

Thanks,

Lalaina

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 05:21:29 CDT