我正在执行一个存储过程,但它在某个时候失败了, 当前错误代码不帮我找到错误的位置和确切位置 我想知道它正在失败,所以想要在执行时逐行输出。 例如:如何在oracle存储过程中逐行打印
create or replace
-- decaring required variable
PROCEDURE "PROC_DATA_TABLE_DETAILS" IS
FOR TABLEDETAILS IN (SELECT * FROM user_tables)
LOOP
dbms_output.put_line (TABLENAME);
select NUM_ROWS INTO COUNTRECORDS from all_tables where owner not like 'SYS%'and TABLE_NAME = TABLEDETAILS.TABLE_NAME;
FOR FIELDSDETAILS IN (SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = TABLENAME)
LOOP
FIELDNAME :=FIELDSDETAILS.COLUMN_NAME;
dbms_output.put_line (FIELDNAME);
execute immediate 'SELECT NVL(count(*),0) FROM ' ||TABLENAME || ' WHERE '|| FIELDNAME || ' is not null ' into TEMPNONBLANK;
END LOOP;
INSERT INTO DATA_TABLE_DETAILS VALUES (TABLEDETAILS.TABLE_NAME,COUNTFIELDS)
END LOOP;
END PROC_DATA_TABLE_DETAILS;
+0
开始语句/关键字缺少。 –