Hi, I am trying to link OBIEE from oracle apex using GO URL with valid cookie name. set define off select 'http://obieeprdURL:PortNO/analytics/saw.dll?bieehome&NQuser='||OPRID||'&NQpassword='||SESSIONCOOKIENAME as SESS_URL from PS_TABLES@DBLINK where oprid = 'USERNAME'; OPRID is peoplesoft user name we have a function SESSIONCOOKIENAME that generates the cookie at the run time. Placed the below URL but somehow it is not working. 'http://obiee_prd_url:portNo/analytics/saw.dll?bieehome&NQuser='||:APP_USER||'&NQpassword='||func_SESSIONCOOKIENAME(:APP_USER)
Discy Latest Questions
Hi! I use LoV item with shuttle. I tried to create save process for shuttle item, but when I move value to right side I got error: Error computing item source value for page item P8_SHUTTLE. ORA-01722: invalid number When I click OK button value is inserted. When I move values from right to left side there is no error. Save process: DECLARE vTAB APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN vTAB := apex_util.string_to_table (:P8_SHUTTLE); DELETE FROM role_privileges WHERE fk_role_id = :P8_ROLES; FOR i IN 1 .. vTAB.count LOOP INSERT INTO role_privileges (fk_privilege_id, fk_role_id) VALUES (vTAB(i), :P8_ROLES); END LOOP; END;
I am using cards to display diagrams. When page is load or reload diagram is displayed well, but when I use Faceted Search cards region is refreshed(without reload) and diagram doesn't fit in card. On page load or after reload page: After using Faceted Search and region refresh: Cards region query select ID, TITLE as CARD_TITLE, DIAGRAM, apex_page.get_url ( p_page => 21, p_items => 'P21_ID', p_values => "ID") as CARD_LINK, null as CARD_INITIALS, null as CARD_SUBTITLE, null as CARD_SUBTEXT, '<!DOCTYPE html> <html> <head> <meta charset="UTF-8" /> <!-- viewer --> ...
Hi, I'd been implementing the tutorial for adding Add/Del/Save buttons to a interactive grid (https://www.foxinfotech.in/2019/10/oracle-apex-interactive-grid-create-custom-add-edit-save-and-delete-buttons.html ) using Dynamic Actions which now works well. However I have a couple of questions/issues that I hope you'll be able to help with. When I add a new item to my grid, I need to check that that item doesn't already exist, and When I delete an item, I need to run some PL/SQL to check another table to see that that item is not used there. In both issues, I can create the core code but I just need to know how I can access the various items on the page and pass them through to the DA execution item to prevent/allow the action accordingly. TIA Martin
Platform: Oracle Database 19c Enterprise Edition Release 18.104.22.168.0 (A pleasure to have moved to Oracle 19c) Hello, As always, my admiration for your time and expertise. After hours of exhaustive exploration and Oracle Docs and support pages, we were unable to solve this issue. Utility: loadjava Action: Trying to load a .jar file using loadjava and call Java Class using PL/SQL Api. This java class simply adds value to the JMS queue and returns a String with status as SUCCESS. Note: Hello.java worked successfully. Issue: After a successful load using loadjava, When we execute via Oracle PL/SQL Function, we are getting the following error. "ORA-29532: Java call terminated by uncaught Java exception: javax.jms.JMSRuntimeException: Cannot instantiate class: weblogic.jndi.WLInitialContextFactory" Our Trials: We thought it is missing some libraries of Weblogic. So we added wlthint3client.jar separately using loadjava utility. We also tried to add wlthint3client.jar under "ORACLEHOME\jdk\jre\lib\ext" so that it gets picked up at instance load. But the error keeps happening. We included this as a part of our original jar yet the same issue. We went back to basics, and created both a Hello.java and Hello.class and loaded them using loadjava. With PL/SQL function called this class, and it worked successfully. Only when we load a .jar file ...