User Tools

Site Tools


kurs:execute_immediate

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
kurs:execute_immediate [2008/11/06 13:30]
mh
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>​
kurs/execute_immediate.txt ยท Last modified: 2014/11/18 12:48 by mh