|
 |
|
Oracle Tips by Burleson |
Branch
Type
Example:
declare
n_page_id integer;
begin
select 2205 into n_page_id from dual;
return n_page_id;
end;
Example:
declare
s_url varchar2(200);
begin
select '
http://www.rampant-books.com'
into s_url from dual;
return s_url;
end;
Example:
owa_util.redirect_url(
'http://www.google.com' );
-
Branch to Page:
It does just what it says.
-
Branch to Page
Identified by Item (Use Item Name): This branch will use the
value of another page item to determine the application page id to
branch to. This can be used if the user is provided with a select
list of areas for them to branch to, such as Employee Management,
Payroll, Billing, etc.
-
Branch to Page
or URL: This is the default branch type presented when
creating a branch and is the most common. Using this type, it is
possible to set many of the properties available in the other branch
types. The reason it is the most common is because the page to
branch to can be set, along with the page items to set, and with
which values to set them. It is also possible to set the pages for
which to clear the session state at the same time. This branch type
allows this to be set in the create branch wizard. Even though it
is manually possible to go back and edit the branch later to set
these properties, it is convenient to do it in the wizard.
-
Branch to URL
Identified by Item (Use Item Name): This branch will use the
value of another page item to determine the URL to branch to. This
can be used if the user is provided with a select list of web sites
for them to branch to, such as Google, Amazon, CNN, etc.
The above book excerpt is from:
Easy
HTML-DB Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent
Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|