PL/SQL: How to detect which browser is being used?

I'm using the pl/sql htp package to create开发者_JS百科 simple web pages. Now I need to use different templates based on the device accessing the pages (Desktop Browser or Mobile Blackberry Client ).

Is this possible in pl/sql?

This will tell you:

owa_util.get_cgi_env('HTTP_USER_AGENT')

Having never used oracle or htp, I can't provide much help, but a bit of googling suggests you can use procedure utl_http.get_header, and the particular header you are interested in would be User-Agent.

I suggest looking up the utl_http package for more information.