Annex Download

[gokden]

Good morning guys ...

Well I'm wanting to imply a download routine at Apex.
axei The following Oracle tutorial: http://download.oracle.com/docs/cd/B310 ... m#CIHHEHCJ
It worked out, but when I'm going to download through the procedure he says, the following error appears:

Select all

 403 Forbidden. 
You don't have permission to access /pls/apex/USINAS.download_my_file on this server.

Someone knows the porque of this error ??

grateful ....

[victorhugomuniz]

The Owner user of procedure has privileges about this path ??

[gokden]

hehehehe = D
staff, I discovered the error here = D

is the following,
when you will call a procedure, pacakge, funcion or anything else, You need to give privilege to explicitly run.

To give the privilege follow this tutorial: http://www.adp-gmbh.ch/ora/plsql_gateway/ex_1.html
only confirm before the Owner of procedure "WWV_FLOW_EPG_INCLURE_MOD_LOCAL"

Select all

 select owner from dba_objects where object_name = upper('wwv_flow_epg_include_mod_local')

99]] and place the correct Owner at the time of recompiling the function wwv_flow_epg_include_mod_local ...

and if you want to release access to any procedure, it is only to collapse "Return true" at the beginning , which also works.

Obs1: Only when you are using in EPG (embeddes PL / SQL Gateway)

Any questions, we are there ...

vlww

[victorhugomuniz]

Good that you have solved your problem ..

[gokden]

the good thing is that now whoever has this problem already knows how to solve = D
this is not to read the documentation and want to know everything = D

plus an important observation is that when Putting the name of the procedure that will be performed, in Function, must put the OWNER.PROCEDURE_NAME
as well:

Select all

create or replace function APEX_030200.wwv_flow_epg_include_mod_local(procedure_name in varchar2) 
return boolean 
is 
begin 
    --    return false; -- remove this statement when you modify this function 
    -- 
    -- Administrator note: the procedure_name input parameter may be in the format: 
    -- 
    --    procedure 
    --    schema.procedure 
    --    package.procedure 
    --    schema.package.procedure 
    -- 
    -- If the expected input parameter is a procedure name only, the IN list code shown below 
    -- can be modified to itemize the expected procedure names. Otherwise you must parse the 
    -- procedure_name parameter and replace the simple code below with code that will evaluate 
    -- all of the cases listed above. 
    -- 
--    return TRUE; 
    if upper(procedure_name) in ('DOWNLOAD_MY_FILE', 'USINAS.DOWNLOAD_MY_FILE') then 
        return TRUE; 
    else 
        return FALSE; 
    end if; 
end wwv_flow_epg_include_mod_local; 

If so, I put on the two ways, just to have absolute CTZ that will not lock = D

[gokden]

Another tip = D
when you give the HTTP 404 error, saying that the package was not found.
It's because I have to give the Grant run on the package that will download, pair to the user apex_public_user or for the public

this has just happened to me = D heheheheh