Interested to Buy Any Domain ? << Click Here >> for more details...
Dear All,
Question for this Week
Find out possible error(s) (either at compile
time or at runtime) in the following PL/SQL block. State
the reason(s) and correct the errors.
Declare
Cursor C1 is select ename, sal, comm from emp;
Begin
For i in C1 Loop
If i.comm between 299 and 999 then
Dbms_output.put_line(i.Ename || ‘
** Good Commission’);
Elsif i.comm > 999 then
Dbms_output.put_line(i.Empno || ‘
** Very Good Commission’);
close C1;
Else
Dbms_output.put_line(i.Ename || ‘
** ’ ||nvl(i.comm,‘O’));
End if;
End Loop;
End;
- 7 Answers
- 13133 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / rinson
Nobody mentioned errors..(both runtime and compile time)
let's go through the errors
A. compile time errors
1. Encountered symbol "‘" when expecting single qoutes
double quotes etc.
2. When we replace all these symbols to single quotes
next error -- > empno must be declared will come,
since it is to be declared in cursor C1.Here they
may be expecting ename instead of empno.
3. Then it will show next error-->
Numeric or value error since nvl function contains
different datatypes.we can change this to 0.
Now all compile time errors removed.
B. Run Time Errors
1. Since cursor for loop implicitly open,fetch and close
cursor , there is no need to close cursor in second if
condition.Actually compiler will not allow to close a
cursor in a cursor for loop.
it will throw the run time error
ora-01001 invalid cursor.
By removing close c1; all errors will be removed.
PL/SQL code without any errors is exact as given above
by Ramprasad.
Thanks
Rinson KE
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is the importance of sqlcode and sqlerrm?
What is the default isolation level in sql server? : Transact sql
What is sqlerrd?
what are properties of a transaction? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
what are sequences
Which is faster joins or subqueries?
How to connect a sql*plus session to an oracle server?
What does plv msg allows you to do?
Explain the uses of control file.
What is a string data type in sql?
What is the difference between inner join and natural join?
What is the advantage of nosql?
what are myisam tables? : Sql dba
What do you mean by dbms? What are its different types?
