Urgent issues indicate a live system that has gone down, and/or the company is losing money and/or people's lives are at risk.
For urgent issues, please raise a priority service request with Oracle via My Oracle Support using your customer support ID.
These community forums are manned by volunteers giving their own time to help people with technical issues. To suggest that your issue is "urgent" to such people is considered extremely rude as it suggests that people should stop what they are doing to help you.
It is also very rude to all the other people who are seeking help for their issues, as it suggest that your issue is more important than theirs... which is isn't.
Please read: Re: 2. How do I ask a question on the forums?
Please do not be put off by our first reactions. Many questions come here that are very much like yours, and it is hard to keep explaining the same things over and over again.
You want to know how to make your approach work.
We are almost certain you should take another approach.
Would you be so kind as to explain, as best you can, what you are trying to accomplish? Try to forget your approach to the problem and just explain the problem. Leave PL/SQL out of it altogether. Say exactly what the input is and what output you expect and why you expect exactly that output.
When you ask a question, you should always provide CREATE TABLE and INSERT statements so we can create the input ourselves. That is the only way we can test our solutions before proposing them. Without testing, you will get solutions that don't work.
Best regards, Stew