Dicas para iniciantes no APEX

#############################
DICAS ORACLE EXPRESS
#############################
Fazer o download do ORACLE EXPRESS
http://download.oracle.com/otn/nt/oracle10g/xe/10201/OracleXEUniv.exe

e instalar na maquina.


#############################
DOWNLOAD DO APEX
#############################
Fazer o download do ORACLE APEX

http://download.oracle.com/otn/java/appexpress/apex_3.1.2.zip

#############################
REFERENCIAS INSTALACAO DO APEX
#############################

http://www.apex-blog.com/oracle-apex/installing-apex-tutorial-23.html
http://jeffkemponoracle.blogspot.com/2007/07/apex-30-via-embedded-plsql-gateway.html
http://www.liberidu.com/blog/?p=122


#############################
RESOLVENDO PROBLEMAS CONEXAO XDB
#############################
http://afsungur.wordpress.com/2008/08/

#############################
FAZENDO USUARIO CAIR DIRETO NA SUA APLICACAO
#############################

Para redirecionar uma aplicacao, em uma devida URL use a procedure abaixo:

CREATE OR REPLACE
PROCEDURE myapp IS
BEGIN
OWA_UTIL.REDIRECT_URL(
'/apex/f?p=105');
END;


#############################
CRIAR UM DAD
#############################
Criar um DAD para sua aplicacao.

Geralmente necessitamos de um DAD, direct access database para acessar a aplicacao diretamente, sem a necessidade utilizar o mesmo usuario do APEX, visto que qualquer alteracao o usuario do APEX podera ser removido ou alterado sem maiores delongas.

Os passos para se criar o seu DAD, ou seja para que seu usuario seja acessado diretamente pela WEB faremos o seguinte:

crie seu usuario:

create user abc identified by secretpassword;

begin
DBMS_EPG.create_dad (
dad_name => 'ABC',
path => '/abc/*');
DBMS_EPG.set_dad_attribute (
dad_name => 'ABC',
attr_name => 'database-username',
attr_value => 'ABC');
dbms_epg.authorize_dad('ABC','ABC');
end;
/

informe o grant se a sua procedure esta no usuario flows_030000, ou seja diferente do usuario abc;

grant execute on flows_030000.myapp to abc;

create public synonym myapp for flows_030000.myapp;

(Note 1: if you move the procedure out of the flows_030000 schema, you'll need to modify the above commands)
(Note 2: the name of the DAD is case-sensitive, so if you see "ABC" above, don't put in "abc", and vice versa)
(Note 3: don't use "secretpassword" for your password!)

Once the above is done, a user can run myapp via a url like:

Podemos testar a procedure diretamente atraves da chamada:

http://MINHAMAQUINA/abc/myapp

Voce pode passar parametros se caso necessario:

http://MINHAMAQUINA/abc/myapp?param1=XXX&PARAM2=XYZ


Voce podera designar uma pagina padrao para que se caso o usuario vindo da internet, nao digitar a procedure podera entao ser direcionado diretamente para a procedure padrao.

begin
DBMS_EPG.set_dad_attribute (
dad_name => 'ABC',
attr_name => 'default-page',
attr_value => 'myapp');
end;
/

Entao a chamada poderia ser executada assim:

http://myapexserver/abc