Application Express :: How To Build Access Control Page Download Spreadsheet Data

Jul 2, 2013

why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:

[URL]............

returns nothing for me!

View 1 Replies


ADVERTISEMENT

Application Express :: How To Access Data Of All Users In A Page

Jan 23, 2013

I have installed APEX on my local machine, created a workspace, and added a few users with roles.

I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?

View 5 Replies View Related

Application Express :: ORA-24247 / Network Access Denied By Access Control List

Apr 5, 2013

When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.

I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.

ORA-24247: network access denied by access control list

<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI

<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?

DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;

[code]...

View 4 Replies View Related

Application Express :: Put A Download Button In Report Page

Jun 26, 2013

I have requirement like I have to put a download button in report page and clicking it will download only few of the columns only (specified one). I am using Apex 4.2.

View 7 Replies View Related

Application Express :: IR Report Page With Download (specific) Column Security?

Apr 24, 2013

i have IR report page and download column as blob,how can security applied in specific column wise?e.g. Report page have more rows, and applied query in condition.

Select ID,dbms_lob.getlength(Blob_file) Download  from Document_master
where Created_by=UPPER(:APP_USER)
OR
  (exists (select ''   from   apex_workspace_group_users awgu
where  awgu.user_name =:app_user  AND awgu.GROUP_NAME='EMPLOYEE_GROUP'
)
)

Now all the rows with Download column to see EMPLOYEE_GROUP users,but i need control the download column only except Created_by=UPPER(:APP_USER) ,this case how can do the security.

View 5 Replies View Related

Application Express :: Access For External File In Apex Page?

May 21, 2013

How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?

I created a page and button for link but struggling for above.

View 5 Replies View Related

Application Express :: Create A Global Region In Page 0 And Then Access It From Other Pages?

Apr 26, 2013

I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.

To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.

Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.

My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)

View 7 Replies View Related

Application Express :: Reset Data Picker Page Item By Selection Page Item

Aug 23, 2012

Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.

Issue here is unable to find a way to set the page range item values based on the quarter field selection

how to reset the page item fields.

View 0 Replies View Related

Application Express :: Build A Menu Framework

Jun 27, 2012

I have built a Menu Framework using the following instructions.

[URL]........

I am facing 2 problems.

1. If the user is in a child application and clicks logout. He is taken to the login screen of the master application (Correct), but once he enters login details, he is returned to the child application (False). I think he should be returned to the Home page of the Master application.

2. If I set Session Timeouts in the Edit Security Attributes of the applications. Then if the user is timed out, he is sent to the login screen of the Master application (Correct). If he then logs in, he is sent the the Home page of the Master application (Correct).

Now if he clicks a link to a child application he is then sent back to the Master application login screen. He then has to login again. He is sent to the Master Home page and everything is then ok.

View 1 Replies View Related

Application Express :: How To Build A Button On Click Of Which Opens A List Below It

Jun 29, 2013

I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action. 

View 7 Replies View Related

Application Express :: Can Open Page 306 As Modal Window But Page Closes Immediately

Nov 13, 2012

i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.

Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.

as defined in my button attributes.

Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.

View 3 Replies View Related

Application Express :: Add Field In Page Title Or Repeat Header On Each Print Page

Jun 4, 2013

We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.

Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.

View 1 Replies View Related

Application Express :: How To Create A Text That Links To Another Page From The Login Page

May 21, 2013

In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.

With a button, its simple because its inbuilt there,but I do not want a button,just this: Register

I want also to have the text in color not black.

View 6 Replies View Related

Application Express :: Passing Item Value To Another Page Via Button Set To Redirect To Page

Jul 16, 2013

I am new to APEX and I am developing an application to manage Oracle database user accounts.  I have a page (8) that has text items for the username and the database name.  I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account.  I have another button that should:

get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11

The issue is that FIND_USER_IN_DB does not get populated and page 11

which is a simple report with the following query:

SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB; 

How do I accomplish this?

View 8 Replies View Related

Application Express :: Navigate To Authorized User Page 5 - Keeps On Going To Page 1

Aug 17, 2012

I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .

View 8 Replies View Related

Application Express :: Authorization For CSV Download

Jun 12, 2012

I need to limit the usage of the CSV download to some users : how can I do that ? Is it possible to connect CSV download to a custom button ?

View 4 Replies View Related

Application Express :: Download File In 4.0.2?

Jan 28, 2013

I am migrating my application from Apex 3 version to Apex 4.0.2. In previous version , downloading a file was working fine.

But now, it is not working..Is there any changes to be done with the properties?

I was using wpg_docload.download_file to download the file.

View 3 Replies View Related

ORA-24247 / Network Access Denied By Access Control List (ACL)

Dec 12, 2012

I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18

is it possible to send mails from oracle database in STANDARD Edition?

View 1 Replies View Related

SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)

Nov 15, 2011

While Running the proc,it's raising the below error.

Error report:

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1

[code]....

View 12 Replies View Related

Application Express :: Upload And Download BFILE

Sep 12, 2012

Is there any way to upload a file to APEX as BFILE instead of BLOB? I need it to be BFILE since I will be only using XE which means I have limited data storage and unfortunately the system will allow users to upload and download files of different formats (.exe,.bat ) etc. which can be as big as 10MB. Also, how to download these files considering the authentication of the application.

View 3 Replies View Related

Application Express :: CSV Download Russian Characters

Aug 5, 2013

Apex 3.2 I have russian data in my database.When I display it in a report, everything is ok.If I export the report to csv, then the russian characters display incorrectly. EgIn report БУЛКА 10:1 ЗАМОРОЖ.In export ¿¿¿¿¿ 10:1 ¿¿¿¿¿¿¿. My settings in shared components areApplication Primary Language: English (United Kingdom) en-gbApplication Language Derived From : Use Application Primary Language.

View 24 Replies View Related

Application Express :: Custom Download Procedure Not Working?

Oct 16, 2013

I have created a custom download procedure to download uploaded files from custom table records which are displayed via links and i call my procedure as #OWNER#.my_file?p_file=#ID#. Now the problem this procedure call works in my development system not any other system.

is there any grant i need to provide but i don't want to grant to public also apex 4.1.1  create or replace PROCEDURE

my_file(p_file in number) AS        v_mime  VARCHAR2(500);        v_length  NUMBER;        v_file_name VARCHAR2(400);        Lob_loc  BLOB;BEGIN    SELECT trim(MIME_TYPE), BLOB_CONTENT, trim(filename),DBMS_LOB.GETLENGTH(blob_content)          INTO v_mime,lob_loc,v_file_name,v_length      FROM EMP.FILE_attachments                WHERE id = p_file;     owa_util.mime_header( nvl(v_mime,'application/octet'), FALSE );        htp.p('Content-length: ' || v_length);     htp.p('Content-Disposition:  attachment; filename="'||replace(replace(substr(v_file_name,instr(v_file_name,'/')+1),chr(10),null),chr(13),null)|| '"');  owa_util.http_header_close;                wpg_docload.download_file( Lob_loc ); ---------------------------------

View 14 Replies View Related

Application Express :: Download Link On Column From Another Table?

Apr 1, 2013

I'm a APEX newbie using APEX 4.1. I have a table with engineering drawing information (drawing number, title, revision, etc.) and another table with the corresponding drawing files (pdfs stored as blobs where the filename is the drawing number with a pdf extension). The user wants to search for a particular drawing by drawing number from the drawing info table and if the drawing number exists in the drawing files table the drawing number will also be a download link for the file, if the drawing number doesn't exist in the drawing files table than the drawing number will display as plain text (not as a download link).

View 1 Replies View Related

Application Express :: Open Download File In New Window?

Jun 5, 2013

How to  make an item as a  mandatory field dynamically with the change of another item in different regions

View 8 Replies View Related

Application Express :: Hide / Show Column In Download To CSV?

Nov 27, 2012

I have an IR where I have to show a column in report, but hide it while downloading to CSV.

I get this by having a condition on this column - NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF')  I also have a column where I have to hide it in the report, but show it while downloading to CSV.

I am able to hide it, but this column doesn't show up while downloading.I am using this condition on this column NVL(:REQUEST,'EMPTY') IN('CSV','XLS','PDF','XML','RTF') APEX - 4.0.2

View 1 Replies View Related

Application Express :: Configure In Order To Download A Report With Excel

Apr 9, 2013

In my xe installation, what should i have to configure in order to download a report with excel. not with csv.

View 2 Replies View Related

Application Express :: Remove HTML From Interactive Report Download?

Sep 27, 2012

I have interactive reports where the column link on a specific column has to be dynamic, that means, it cannot be hard coded in the column link attributes. The following is an example of one such report query:

case when d.object_type_description ='Business Service' then

'< href="f?p='||:app_id||':183:'||:app_session||'::::P183_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'

when d.object_type_description = 'Real Time Event' then

'< href="f?p='||:app_id||':162:'||:app_session||'::::P162_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'
else
null
end

as "OBJECT NAME"As you see in the above example, the link on the "Object Name" column could either redirect to page 183 or to page 162 based on the "Object Type Description" column.

The column attribute of the "Object Name" column has "Display Type" set to "Standard Report Column". That works perfectly fine in the UI of the report. However, if I download the IR data (in any format) from the Actions -> Download menu, the object name column values are downloaded with the HTML characters as:

< href="f?p=15548:183:6072319179284::::P183_OBJECT_ID:255245470513999672860510787772603748464">JP010000</>where JP010000 is the object name.

Is there a way I can strip the HTML from the column values in the downloaded files?I am using Apex 4.1.

View 4 Replies View Related

Application Express :: BLOB Action - Implement File Upload And Download Function

Sep 11, 2013

In my project, I implement file's upload and download function by  "BLOB Support in Forms and Reports" of  official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table  for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.

View 1 Replies View Related

Application Express :: Display List Of All Users On Page / Accessing Or Using Application

Mar 23, 2013

i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?

View 1 Replies View Related

Application Express :: JSON Error When Trying To Redirect To Another Page In Same Application?

Jul 23, 2013

I'm trying to set up a PL/SQL dynamic action that is triggered by clicking on a button.  The dynamic action sets two values in a table and then I would like to redirect to another page.  Setting the values works fine.  The code is below: 

declarel_information varchar2(255) := :P94_FILENAME;BEGINcommit;UPDATE VDI_METADATASET CREATEUSERLISTNAME = l_information,    CREATEUSERLISTON = sysdate();commit;htp.init;owa_util.redirect_url('f?p=&APP_ID.:81:&APP_SESSION.::NO:::');END; The redirect fails with the following eror: "Error: parseerror: JSON.parse: unexpected non-whitespace character after JSON data" 

how to redirect to a page from within PL/SQL .  None of them result in success. 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved