Re: truncate table in stored pl/sql proc
From: David Smith <skandor_at_worldnet.att.net>
Date: Mon, 10 May 1999 10:05:31 -0500
Message-ID: <7h6sfc$83k$1_at_bgtnsc02.worldnet.att.net>
end clean_ipl;
Date: Mon, 10 May 1999 10:05:31 -0500
Message-ID: <7h6sfc$83k$1_at_bgtnsc02.worldnet.att.net>
Here's an example of how it's used.
procedure clean_ipl is
l_cursor integer; l_rtn number; begin -- l_cursor := dbms_sql.open_cursor; dbms_sql.parse(l_cursor,'truncate table mcsa.ipl_remarks',dbms_sql.v7); l_rtn := dbms_sql.execute(l_cursor); dbms_sql.close_cursor(l_cursor); -- l_cursor := dbms_sql.open_cursor; dbms_sql.parse(l_cursor,'truncate table mcsa.ipl_ch',dbms_sql.v7); l_rtn := dbms_sql.execute(l_cursor); dbms_sql.close_cursor(l_cursor); -- l_cursor := dbms_sql.open_cursor; dbms_sql.parse(l_cursor,'truncate table mcsa.ipl',dbms_sql.v7); l_rtn := dbms_sql.execute(l_cursor); dbms_sql.close_cursor(l_cursor); -- delete from mcsa.ipl_ei; commit; -- delete from mcsa.ipl_hd where date_created is not null; commit; --
end clean_ipl;
Big Bear wrote in message <3736EE84.2901613B_at_hotmail.com>...
>hello,
>
>could anyone out there tell me if it is possible to include truncate
>table command in a pl/sql stored procedure. i tried it but when i
>compile it gives error "expecting 'table' when expecting......"
>
>thanks & regards.
>
Received on Mon May 10 1999 - 17:05:31 CEST