Need help with run in PL/SQL but NOT in SQL+
There are two similar issues that I have and I can't figure this out.
-------------------------------------------------------------------------
DECLARE
--FUNCTION COPY_FROM_SVO_TPE_APL(BANO IN INTEGER) RETURN INTEGER IS
CURSOR C1 IS
SELECT ROWID "RID"
FROM TP_ENTRY.APPEALS@SDEV_APL.ASSESSOR.MARICOPA.GOV
WHERE BATCH_NUM = &BANO AND
TRANS_STAT = 0;
RET INTEGER := 0;
BEGIN
DBMS_OUTPUT.ENABLE(BUFFER_SIZE => NULL);
FOR X IN C1 LOOP
BEGIN
INSERT INTO TP_ENTRY.APPEALS
SELECT * FROM TP_ENTRY.APPEALS@SDEV_APL.ASSESSOR.MARICOPA.GOV
WHERE ROWID = X.RID;
IF(SQL%ROWCOUNT = 1) THEN
RET := RET + 1;
UPDATE TP_ENTRY.APPEALS@SDEV_APL.ASSESSOR.MARICOPA.GOV
SET TRANS_STAT = 1
0