Home » SQL & PL/SQL » SQL & PL/SQL » empty the table
empty the table [message #38720] Wed, 08 May 2002 07:51 Go to next message
Maya
Messages: 7
Registered: May 2002
Junior Member
Hi.
I'm trying to empty the table. Within a procedure, I have:
v_cursor:=DBMS_SQL.open_cursor;
v_command:='DELETE FROM podtl';
DBMS_SQL.parse(v_cursor, v_command,DBMS_SQL.native);
DBMS_SQL.close_cursor(v_cursor);
Procedure executes CREATE, INSERT, but not DELETE. It doesn't report the error, it seems to execute fine, but it just doesn't perform DELETE command, so at the end there are still records in podtl. Does anybody know why?
Thanks. MS

Report message to a moderator

Re: empty the table [message #38721 is a reply to message #38720] Wed, 08 May 2002 08:23 Go to previous message
Maya
Messages: 7
Registered: May 2002
Junior Member
Duh! This actually works without using dbms_sql. I solved the problem. MS

Report message to a moderator

Previous Topic: how often is recomended to use commit in a loop
Next Topic: What does "Rownum=1" Do in this function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 07 17:11:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.