oracle ´æ´¢¹ý³Ì ¶Áȡ˳Ðò´íÎó

µ÷ÓÃÏÂÃæ´æ´¢¹ý³Ì ³öÏÖ ¶Áȡ˳Ðò´íÎóµÄ Ìáʾ£¬
´ó¼Ò°ïæ¿´Ï лл¡«¡«£¡


PROCEDURE RetrieveNonblockingInstanceIds
(
p_OWNER_ID IN INSTANCE_STATE.OWNER_ID%TYPE := NULL
,p_OWNED_UNTIL IN INSTANCE_STATE.OWNED_UNTIL%TYPE := NULL
,p_NOW IN DATE
,p_WORKFLOW_IDS OUT RefCursor
)
AS
BEGIN
OPEN p_WORKFLOW_IDS FOR
SELECT
INSTANCE_ID
from
INSTANCE_STATE
WHERE
BLOCKED = 0
AND STATUS NOT IN (c_STATUS_COMPLETED, c_STATUS_SUSPENDED, c_STATUS_TERMINATED)
AND (OWNER_ID IS NULL OR OWNED_UNTIL < p_NOW)
FOR UPDATE;

IF NVL(SQL%ROWCOUNT, 0) > 0
THEN
UPDATE INSTANCE_STATE
SET
OWNER_ID = p_OWNER_ID
,OWNED_UNTIL = p_OWNED_UNTIL
WHERE
BLOCKED = 0
AND STATUS NOT IN (c_STATUS_COMPLETED, c_STATUS_SUSPENDED, c_STATUS_TERMINATED)
AND (OWNER_ID IS NULL OR OWNED_UNTIL < p_NOW);
END IF;
END;

---

Ïêϸ´íÎóÌáʾ£¿

---

ORA-01002: ¶ÁÈ¡Î¥·´Ë³Ðò

---

Ó¦¸ÃʹÓÃsys_refcursor

---

ÈõÈõµÄÌá¸öÒÉÎÊ£º
¼ÙÈçfor updateÕâÀïËøÁË3Ìõ£¬ÔÚifµÄʱºò£¬ÓбðµÄ»á»°²åÁËÒ»Ìõ¸ÕºÃÂú×ãÌõ¼þ£¬ÔòÏÂÃæµÄ¸üл᲻»áÓÐ4Ìõ°¡¡£

---

Cause In a host language program, a FETCH call was issued out of sequence. A successful parse-and-execute call must be issued before a fetch. This can occur if an atte