#############################
DICAS ORACLE EXPRESS
#############################
Fazer o download do ORACLE EXPRESS
http:\/\/download.oracle.com\/otn\/nt\/oracle10g\/xe\/10201\/OracleXEUniv.exe<\/p>\n
e instalar na maquina.<\/p>\n
#############################
DOWNLOAD DO APEX
#############################
Fazer o download do ORACLE APEX<\/p>\n
http:\/\/download.oracle.com\/otn\/java\/appexpress\/apex_3.1.2.zip<\/p>\n
#############################
REFERENCIAS INSTALACAO DO APEX
#############################<\/p>\n
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<\/p>\n
#############################
RESOLVENDO PROBLEMAS CONEXAO XDB
#############################
http:\/\/afsungur.wordpress.com\/2008\/08\/<\/p>\n
#############################
FAZENDO USUARIO CAIR DIRETO NA SUA APLICACAO
#############################<\/p>\n
Para redirecionar uma aplicacao, em uma devida URL use a procedure abaixo:<\/p>\n
CREATE OR REPLACE
PROCEDURE myapp IS
BEGIN
OWA_UTIL.REDIRECT_URL(
‘\/apex\/f?p=105’);
END;<\/p>\n
#############################
CRIAR UM DAD
#############################
Criar um DAD para sua aplicacao.<\/p>\n
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.<\/p>\n
Os passos para se criar o seu DAD, ou seja para que seu usuario seja acessado diretamente pela WEB faremos o seguinte:<\/p>\n
crie seu usuario:<\/p>\n
create user abc identified by secretpassword;<\/p>\n
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;
\/<\/p>\n
informe o grant se a sua procedure esta no usuario flows_030000, ou seja diferente do usuario abc;<\/p>\n
grant execute on flows_030000.myapp to abc;<\/p>\n
create public synonym myapp for flows_030000.myapp;<\/p>\n
(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!)<\/p>\n
Once the above is done, a user can run myapp via a url like:<\/p>\n
Podemos testar a procedure diretamente atraves da chamada:<\/p>\n
http:\/\/MINHAMAQUINA\/abc\/myapp<\/p>\n
Voce pode passar parametros se caso necessario:<\/p>\n
http:\/\/MINHAMAQUINA\/abc\/myapp?param1=XXX&PARAM2=XYZ<\/p>\n
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.<\/p>\n
begin
DBMS_EPG.set_dad_attribute (
dad_name => ‘ABC’,
attr_name => ‘default-page’,
attr_value => ‘myapp’);
end;
\/<\/p>\n
Entao a chamada poderia ser executada assim:<\/p>\n
http:\/\/myapexserver\/abc<\/p>\n","protected":false},"excerpt":{"rendered":"
#############################DICAS ORACLE EXPRESS#############################Fazer o download do ORACLE EXPRESShttp:\/\/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.htmlhttp:\/\/jeffkemponoracle.blogspot.com\/2007\/07\/apex-30-via-embedded-plsql-gateway.htmlhttp:\/\/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 … Continue lendo