Tag: Database 11g

Last weeks I ran into some issues with APEX, so let’s take some time to write something about them. The most recent is about heterogeneous services (also referenced as HS). Here is the case: We have an Oracle DB instance with some APEX applications and in one of those applications I need data from a […]

Result cache… a very cool feature in the 11g database. If you don’t know it, this is a must read: Pl/SQL function result cache in 11g But also watch out with it in Forms 11g. It seems there’s a bug. When compiling a program unit that calls a function with result cache in forms, you’ll […]

  When trying to refresh a materialized view based on a query that uses a mssql table (using the SqlServer Gateway), I run into the following error: ORA-12008: error in materialized view refresh pathORA-01400: cannot insert NULL into (%s)ORA-02063: preceding line from MSSQLDB1ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2537ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2743ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2712 […]

Today was the first time to attend a session in the ‘No Slide Zone’ which is one of the special programs presented at Oracle Open World. During these sessions no slides can be used, in other words this is no typical conference track. The keywords for a ‘No Slide Zone’-session: ‘discussion, interaction, whiteboarding and more’.The […]