Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Redirecting when no data found

xarg-XrcMar 12 2013 — edited Mar 12 2013
Using Apex 4.1.1

I need my application to redirect to another page when user carries out a search and there is no data found. The query in the report is overly complicated and is of type "PL/SQL function body returning SQL query" and needs to be like that. It just wont run on its own.

Initially I tried Javascript to run onLoad & Execute when Page Loads like:
function redirect_on_no_data_found2()
{
	
	// if user came from non-catalogue page
	if($(".nodatafound").html() == "no data found")
	{	
		redirect('f?p=129:8:'+$v('P1_SESSION_ID_VALUE')+':NO_DATA_FOUND:NO::');
	}
	
}
But javascript like this is far too unreliable in IE 7 which is what users use and doesn't work in some instance while works in other.


Is there any other way I could do a redirection without javascript or using APEX_APPLICATION.redirect procedure? Kind of run out of ideas.

Many Thanks.
This post has been answered by jariola on Mar 12 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2013
Added on Mar 12 2013
5 comments
804 views