Hi all, I have a need to create a file on a Windows Server filesystem (please assume I have all the required permissions to do this). My Apex is privately hosted on an IX box (Rackspace provide this to me) and I have a fully routed VPN connection between both environments. What I need to do is send data like a TEXT file of some field values in the Oracle database. The receiving file location is polled by an integration with some labelling software. I do not want to have to retrieve files from the IX filesystem with FTP Etc. I want to write to something like \\servername\sharefolder\filename.txt Is this even possible? Many thanks as always. George ...
Discy Latest Questions
Hello Sir, I am sorry to bothering you with this again.. But I'm just not getting anywhere with the following. The issue is that a user logs in and should be redirected to the corresponding page when clicking the 'Go to last status' button. The corresponding page is stored in a table together with the ID and is always updated when the status changes. In order to know which page should be redirected to for this form ID, I use a function that outputs the page as a return value. I use this result to build the URL and save it in a page element. I use URL Identified by Item as the type for the branching process. Unfortunately I always get an error no data found. Here I am not sure how to pass on the ID of the form. I tried these both methods: Building own url DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :='f?p=&APP_ID.:l_branch_page'|| ':&APP_SESSION.::NO::l_id'|| ':'||:P8_ID; END; 2. apex_page.get_url DECLARE l_branch_page number; l_id number; begin select ID into l_id from TABLE1 where ID=:P8_ID; l_branch_page:= FORWARDING_TO_PAGE(:P8_ID); :P8_URL :=apex_page.get_url(p_page => l_branch_page,p_items=>l_id)||:P8_ID; end; Perhaps an important note, the :P8_ID is set, so the value is known here. Can you please help me here?
Hello Sir, I have the following issue. I have an interactive grid, when clicking on the columns the user is directed to the form. There he can edit the form, e.g. accept or reject it. Depending on this, the user is redirected to another page. I would now like that the next time the person clicks on a column in the interactive grid, this person is redirected to the corresponding page. That is, if he has already edited the form, he should be redirected to the page to which he was redirected when he accepted or rejected the form. I have read your blog on a similar topic https://www.foxinfotech.in/2019/10/create-delete-row-button-for-interactive-report-in-oracle-apex.html and wonder if it would also work for this case or what I would have to change here. I proceeded as described in this tutorial. I use the value of the status from interactive report to redirect to the corresponding page. I use this code snippet from the blog in the interactive report. 5 case when nvl(STATUS,'APPROVED')='APPROVED' then 6 'f?p=&APP_ID.:100:8:&APP_SESSION.::::P8_ID'||ID 7 elsif nvl(STATUS,'REQUESTED')='REQUESTED' then 8 'f?p=&APP_ID.:100:9:&APP_SESSION.::::P9_ID'||ID 9 else 10 '#' 11 end LINK But I always get the error: ORA-00905: missing keyword in line 6. Is something wrong with the URL?
I need a simple application which will enable a user to create a schema and copy tables from another schema into the newly created schema. New Schema name will be entered Source Schema name, from which tables will have to copied from, will be entered.
My workspace in apex.oracle.com was locked, I’ve done reset for workspace password but no chance it’s always locked. I’ve tried admin services but password don’t work. Is there any method to reset admin password or procedure to create a developer or administrator from running application admin page. Please help me I’m beginner. Thanks.
Hello Sir, I am trying to insert data into a read only form using following sql query: begin select s.ID, s.SPID, s.PHONE_NUMBER INTO :P9_ID,:P9_SPID,:P9_PHONE_NUMBER FROM TABLE1 s left outer join TABLE2 f on f.ID=s.ID where f.ID=:P9_TBL2_ID; end; However I always get the error no data found when using the where clause, although the page element has an explicit value (here number 5). When I change the where clause to where f.ID=5; I get the right data inserted into the read only form. Can you please help here?
I want to create a pivot report (Department wise sum salary). I need to use sub_query in pivot. XML cannot be used here. Example: SELECT * FROM ( SELECT DEPARTMENT_ID,SALARY FROM EMPLOYEES ) PIVOT (SUM(SALARY) FOR DEPARTMENT_ID IN (SELECT DISTINCT DEPARTMENT_ID FROM EMPLOYEES) )