I have a IG report .In that customer column source is LOV .. Lov has some special character data. But while saving the details if customer column has t special characters then it is getting saved with blank in the DB. Is there any solution to escape special characters?
Discy Latest Questions
Hi , I have created the IG in oracle apex. In the select query of the IG I am calling the package while clicking on the Validation it's Gettig validated but when I click on the save button in the Page designer the query is not getting saved. But I am able to call other packages and save. I want to know why it not getting saved? Thanks
How to use this query , SELECT LPAD (' ', 3 * (LEVEL - 1), '-') || menu_name, oID FROM MENUS START WITH parent_oid IS NULL CONNECT BY PRIOR oid = parent_oid ORDER SIBLINGS BY menu_name ignore this error: ORA-20999: Column name "LPAD('',3*(LEVEL-1),'-')||MENU_NAME" is invalid for the LOV SQL query. Make sure that you use valid alias names for your columns.
HI, how to download a zip file which is stored in directory with the button click in oracle apex I had written a process to call it but throwing the error as syntaxError: Unexpected token 'P', "PK"... is not valid JSON.. Here is my piece of code written in processing: declare Lob_loc bfile; begin Lob_loc := bfilename('ABC_DIRECTORY','data file.zip'); OWA_UTIL.MIME_HEADER( 'application/zip', FALSE ); htp.p('Content-Disposition: attachment; filename="'||'data file.zip"'); owa_util.http_header_close; wpg_docload.download_file(Lob_loc); apex_application.stop_apex_engine; exception when others then raise_application_error(-20002, SQLCODE||' — '||SQLERRM); apex_application.stop_apex_engine; end;
Hi, I'm building a page in APEX. In that page I have 2 items, "text field with autocomplete" Both of them are getting the LOV from the same table but different column. text_field_1 getting the id_1; text_field_2 getting the id_2 So If I input/select a value from text_field_1 I can set a value automatically to text_field_2 or vice versa. I can do one is to one relationship, like if I enter "bca" in text_field_2, I can set the correct value for text_field_1 which is "2" But I'm having a problem for the one is to many relationship. If I enter "1" in text_field_1, It will return 2 values which are "abc,cba" I'm trying to figure it out on how I list the abc and cba so that I can still choose what value I want from the two. Please someone help me with this?
Hello Guru, Please help me in adding sysdate to region report title. I have Tried &SYSDATE and :SYSDATE ..no luck . The title of the report region will be The Daily Report Statistics for &SYSDATE. I have tried using hidden item; adding Java code to get the value to it to display .. nothing worked. I am using old version of APEX 5 .. I have tried using computation/ before heading/ after heading/ hidden items ... every single way to get the sysdate ..no luck Please assist Thank You SSS_ORACLE_APEX
Hello Everyone, I want to restrict checkbox in interactive grid column, My requirement is in my interactive grid one column as checkbox i want check only one row remaining row disable
Hi, I have two Popup LOV, where with a dynamic action "P4_CUSTOMER" refreshes the other Popup LOV "P4_FORMS": Where I filter it as follows "P4_FORMS": select SYW_FORMS.FORM_NAME as FORM_NAME, SYW_FORMS.FORM_ID as FORM_ID from SYW_FORMS SYW_FORMS where CUSTOMER_ID = :P4_CUSTOMER; Cascading List of Values: P4_CUSTOMER In my shuttle I have the following "P4_ROLES": List of Values select SYW_ROLES.ROL_NAME as ROL_NAME, SYW_ROLES.ROL_ID as ROL_ID from SYW_ROLES SYW_ROLES where SYW_ROLES.CUSTOMER_ID = :P4_CUSTOMER Cascading List of Values: P4_CUSTOMER Source Type: SQL Query (return colon separated value) select SYW_FORMS_ROL.ROL_ID as ROL_ID from SYW_FORMS_ROL SYW_FORMS_ROL WHERE SYW_FORMS_ROL.FORM_ID = :P4_FORMS This is what I have configured in my apex, but I can't get my shuttle to refresh the data without doing a submit page that I run in a dynamic action in "P4_FORMS". Thanks.