Re: Truncation from within a stored procedure
From: Sanjay D. S. <sanjay_at_fsg.prusec.com>
Date: 1996/04/29
Message-ID: <4m368o$1bn_at_prufire4.prusec.com>#1/1
Date: 1996/04/29
Message-ID: <4m368o$1bn_at_prufire4.prusec.com>#1/1
timj_at_baa.uk.sun.com (Tim Jinkerson - Sun UK - Applications Engineer) wrote:
>Can anyone tell me how to truncate a table from within a stored procedure?
>
Oracle 7.1.x and higher versions support dynamic sql. You can create a stored
procedure using dbms_sql package. dbms_sql package supports procedures and
functions like open_cursor, parse, execute. By using these functions in your
stored procedure it will be possible to truncate tables.
Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc.
Received on Mon Apr 29 1996 - 00:00:00 CEST