Select statement in procedures

[Janina k]

Inside a procedure :

SELECT CName into name from Tab_customer where cust_id=2;

The above statement works when it is just a single statement inside the procedure.

But when I add other statements inside the same procedure it returns a null value when I try printing the 'name'.

I find this very strange, because only very few times this happens, otherwise it
works fine!.

What will be the reason for this issue?