Strange Error from Codexpert.
"deftones209" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi,
when I analyse this code with codexpert:
PROCEDURE vi_insert_log (
i_info IN VARCHAR2,
i_operation IN VARCHAR2,
i_requestid IN VARCHAR2
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO BUNDLE_BENEFITS_PROCESS_LOG
(counter, info, datecreated,operations,
hn_requestid
)
VALUES (BUNDLE_BENEFITS_PROCESS_LOG_sq.NEXTVAL, i_info, SYSDATE,i_operation,
i_requestid
);
COMMIT;
EXCEPTION
WHEN OTHERS
THEN
NULL;
DBMS_OUTPUT.put_line ('Error while logging--' || SQLERRM);
END;
Toad codexpert is complaining on the like "DBMS_OUTPUT.put_line.." giving me an error that "Cursor - Avoid procedure or function calls between a SQL operation and an implicit cursor test".
To be honest I cannot see the problem, what is wrong with that code? There is no %FOUND or SQL%ROWCOUNT.
Can you give me a Hint?
Thank you very much!!
Manuel
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/