Skip to main content

Posts

Open modal/inline dialog in Oracle APEX using JS

Analysis: From Oracle Apex 4.2,  Inline dialog can be opened as modal dialog/popup using JS. Open inline dialog region as modal dialog: Step 1: Create static region. Step 2:  Set Template => Inline Dialog. Step 3:  Assign the static id to the region. Fig 1: Set template and Static ID Step 4:  Create button or change one of the report column type to Link. (Action: Redirect URL). Step 5:  Put the below JS to open the region as modal dialog.                javascript:openModal('unitpricedetails');            Fig 2:  Open simple modal dialog Open inline dialog region as modal dialog and pass values to the items: Common Steps:  Step 1 to Step 4. Step 5:  To pass value to that region, create P1_UNIT_ID in the inline  dialog.       javascript:$s('P1_UNIT_ID','#UNIT_ID#');javascript:openModal('unitpricedetai...
1 comment
Read more

Add favicon in Oracle APEX 18.2 Application

Solution: Step 1:   Go to shared components and upload required image. Step 2:  Followed by go to user interface, there we can see the option called FAVICON. Add the below HTML code to the favicon HTML source. <link rel="icon" sizes="16x16" href="#APP_IMAGES#DAMAC-logo.png"> Output:
Post a Comment
Read more

ORA-01017

Analysis: When we tried to access the remote database ( when it was shut down )  objects via database link, system throws an error, Error: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from APEX_EBS_DBLINK 01017. 00000 -  "invalid username/password; logon denied" *Cause:     *Action: Error at Line: 1 Column: 28 Solution:   Up the remote database and access.
Post a Comment
Read more

Oracle APEX - Application Alias [APP_ALIAS]

Objective : How to i replace my App ID with custom name. Solution : Step 1: Click on "Edit Application Properties" . Step 2:  There you find a field called Application Alias, you just change it (Whichever alias you want) . Fig 1. Define Application Alias Step 3:  Add little bit JS on page load in App Global Page [ZERO] .                                                                                      Fig 2. Dynamic action JavaScript  Code: jQuery("a[href*='f?p=&APP_ID.:']").each(function(){ var vThis$ = jQuery(this); vThis$.attr("href",vThis$.attr("href").replace("=&APP_ID.:","=&APP_ALIAS.:")); }); Output: Once you have done the above steps, application URL will be like this,  h...
Post a Comment
Read more

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...
Post a Comment
Read more

Print CLOB data using Oracle PL/SQL

Objective : To print clob data. Solution: Step 1: Create plsql procedure to print the clob. CREATE OR REPLACE PROCEDURE print_clob_to_output (p_clob IN CLOB)  IS    l_offset     INT := 1;  BEGIN    dbms_output.put_line('Print CLOB');       loop         exit when l_offset > dbms_lob.getlength(p_clob);         dbms_output.put_line( dbms_lob.substr( p_clob, 255, l_offset ) );         l_offset := l_offset + 255;     END LOOP;  END print_clob_to_output;  This query will print the complete clob data. Step 2: Call the procedure. DECLARE   l_xml CLOB; BEGIN   SELECT dbms_xmlgen.getxml('select * from emp') xml      INTO l_xml      FROM dual;      print_clob_to_output (l_xml); END; Output: Related Posts: Generating XML data from relational data using ...
Post a Comment
Read more