Oracle Programming language not found cursor

Asked By s.susan74 0 points N/A Posted on - 08/05/2011

In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?

• Status: Open
• Question Views: 873
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By feel_stress 0 points N/A #82051

Oracle Programming language not found cursor

PL/SQL block should be implemented in proper manner otherwise it will generate error and will not execute. Here i have given example below just try to understand it.

DECLARE

v_NewMajor VARCHAR2(10) := 'History';

firstName VARCHAR2(10) := 'Scott';

v_LastName VARCHAR2(10) := 'Urman';

BEGIN

UPDATE lecturer

SET major = v_NewMajor

WHERE first_name = firstName

AND last_name = v_LastName;

IF SQL%NOTFOUND THEN

INSERT INTO lecturer (ID, first_name, last_name, major)

VALUES (20001, firstName, v_LastName,

v_NewMajor);

END IF;

END;

Here what above code will do is? There are four blocks DECLARE,BEGIN,EXCEPTION and END. We have to declare variable in DECLARE section, BEGIN will contain SQL statement, EXCEPTION will contain exception that must be handle by the procedure and at last END will inform that the procedure will end.

About feel_stress

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/23/2011
• Question Category: Oracle Database