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!
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?
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]...
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 Relatedi 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.
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.
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.)
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.
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.
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 Relatedi 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.
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.
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.
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?
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 RelatedI 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 RelatedI 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.
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?
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]....
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 RelatedApex 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 RelatedI 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 ); ---------------------------------
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 RelatedHow to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies View RelatedI 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
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 RelatedI 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.
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 Relatedi 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 RelatedI'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.
