Wednesday, February 19, 2014

Oracle: How to escape an &


Insert into BRMF_VALUE_CATALOG (ID,TITLE,TYPE,CAN_HAVE_CHILDREN,PARENT_ID) values (322,'&MORE','Generic_Suffix_Basket',0,3);
DOES not work
 

escape the & with || chr(38) ||

Insert into BRMF_VALUE_CATALOG (ID,TITLE,TYPE,CAN_HAVE_CHILDREN,PARENT_ID) values (322,chr(38) || 'MORE','Generic_Suffix_Basket',0,3);




See also
http://stackoverflow.com/questions/1137354/oracle-pl-sql-escape-character-for-a
 

SAP Netweaver: 7.31 ""Log files are not loaded yet. Press Refresh after short time"

Problem:
You want to view the logs on a SAP 7.31 J2EE Engine but you get the message
 "Log files are not loaded yet. Press Refresh after short time"

I found a SAP Note that gives a hint with the security settings.

http://www.stechno.net/sap-notes.html?view=sapnote&id=1631616

Solution: Login to the logview via https then it works