I have a quesiton for you all. I have taken a small chunk of code from already existing working PL SQL procedure which is suppose to work but it is not. I have no idea why cursor is throwing error.
Following below is the code and attached screen shot for your reference:-
Martin Vajsar wrote:You cannot declare variables in the code in PL/SQL; move the cursor declaration immediately before the BEGIN line.
Moreover, you're doing a join in the code. It is very ineffective. Do all the joins directly in the SQL, it will perform better.
Thanks my PL SQL block started to work. But could please explain me what do you mean by "Do all the joins directly in the SQL"
I guess, I used joining in SQL only. Is there anything else to do for good performance? Please advice