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

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

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

Oracle PLSQL Cursor Duplicate of final Record

Oracle PLSQL Cursor Duplicate of final Record

loop
 fetch s_cur into s_rec;
 exit  when s_cur%notfound;
  dbms_output.put_line('id:'||s_rec.id||':name:'||s_rec.name);
end loop;

When you have fetched the last record and trying to fetch the next s_cur%notfoundbecomes true but before it has a chance to exit from loop you are outputting the last record once again.