Differences

This shows you the differences between two versions of the page.

--- kurs:execute_immediate [2008/10/23 12:25]
127.0.0.1 external edit
+++ kurs:execute_immediate [2014/09/10 21:22]
127.0.0.1 external edit
@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE DELETE_ROWS
+   ( p_table_name IN varchar2)
+   IS
+   statement_cursor integer;
+   rows_del         number;
+BEGIN
+   statement_cursor := dbms_sql.open_cursor;
+   dbms_sql.parse(statement_cursor,
+                  'delete from '||p_table_name,
+                  dbms_sql.native);
+   rows_del := dbms_sql.execute(statement_cursor);
+   -- dbms_sql.fetch_rows
+   dbms_output.put_line('zeilen geloescht '||rows_del);
+   dbms_sql.close_cursor(statement_cursor);
+END; -- Procedure
+</code>
+<code>
+PROCEDURE COUNT_ROWS
+   ( p_table_name in varchar2
+    )
+   IS
+   row_count number;
+   sql_code  varchar2(1000);
+BEGIN
+   sql_code := 'select count(*) from '||p_table_name;
+   -- objekt namen koennen nicht als bind variablen verwendet werden
+   execute immediate sql_code into row_count;
+   dbms_output.put_line(p_table_name ||' contains '
+                        ||row_count||' rows');
+END; -- Procedure
+</code>

dokuwiki