create or replace
PROCEDURE TESTHM AS
BEGIN
dbms_output.put_line ('TestHm');
FOR r IN (SELECT * FROM myTable)
LOOP
dbms_output.put_line( r.myField );
END LOOP;
dbms_output.put_line (CURRENT_DATE);
END TESTHM;
set serveroutput on;
execute testhm;
No comments:
Post a Comment