Tuesday, August 21, 2018

Banner 9: Overwrite struct xml, function of controller in extension

Banner 9: Overwrite struct xml, function of controller in extension

Banner 9 Extend page with different name

Banner 9 Extend page with different name



Banner 9: Warning error alert message box



Banner 9: Info message, error message, alert message boxes


MessageServices.message("This is info");


MessageServices.setAlertMessageText("aa", "This is xxx.");
MessageServices.showAlert("aa");

/MessageServices.message("sss", userResponse);
//OutputMessageUserResponse

getTask().getGoqrpls().gDisplayAlert(toStr("G$_WARNING_ALERT"), GNls.Fget(toStr("GUAGMNU-0007"), toStr("FORM"), toStr("aaaaaaaaaaaaaaaaaaaaa.")) );

getTask().getGoqrpls().gDisplayAlert(toStr("G$_WARNING_ALERT"), new NString("This is aalert.") );

Banner 9 clear Global, setGlobal variables

Banner 9 clear Global, setGlobal variables

setGlobal (key, value);

removeGlobal (key);

Oracle index hint syntax



Oracle index hint syntax


select /*+ index(customer cust_primary_key_idx) */ * from customer;

Also note that of you alias the table, you must use the alias in the index hint:
select /*+ index(c cust_primary_key_idx) */ * from customer c;

Also, be vary of issuing hints that conflict with an index hint.  In this index hint example, the full hint is not consistent with an index hint:
select /*+ full(c) index(c cust_primary_key_idx) */ * from customer c;


https://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm#i8327
https://logicalread.com/using-index-hints-to-tune-oracle-performance-h01/#.W3zv984zbIU

Friday, August 17, 2018

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: null in Weblogic 10.3

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: null  in Weblogic 10.3


1. Check DataSource xml It's in the domain's
config/jdbc directory. 

2.     Check DB Port 

3. Check user=xxx in properties

4. Some times JRF template causing issue due to ojdbcdms.jar is loaded first 
       Solution: - remove JRF
                      - or exclude ojdbcdms.jar from CLASSPATH
                      - or Upgrade to Weblogic12c

 

SQLPlus output to a file


SQLPlus output to a file

spool c:/output.txt
turn off:
spool off

AWS how to delete VPC when it has error with Network interface , Gateway decencies

   how to delete VPC when it has error with Network interface , Gateway decencies  in AWS 1. Check if it is running on EC2 instance then Sto...