Monthly Archives: luglio 2014

ORA-600 Lookup Error Categories (part 1c)
  • 23
    Lug

ORA-600 Lookup Error Categories (part 1c)

Internal Errors Categorised by mnemonic kpor  progint/opi support for streaming protocol used by replication kposc  progint/kpo support for scrollable cursors kpotc  progint/opi oracle side support functions for setting up trusted external procedure callbacks kpotx kpov  progint/kpo support for managing local and distributed transaction coordination. kpp2 kpp3  sqllang/parse kpp2 - parse routines for dimensions; kpp3 - parse support for...

Read More
ORA-600 Lookup Error Categories (part 1b)
  • 16
    Lug

ORA-600 Lookup Error Categories (part 1b)

ORA-600 Lookup Error Categories   In the Oracle Server source, there are two types of ora-600 error : à the first parameter is a number which reflects the source component or layer the error is connected with; or at the first parameter is a mnemonic which indicates the source module where the error originated. This type of internal...

Read More
EXPLICIT CURSORS – modify tables
  • 9
    Lug

EXPLICIT CURSORS – modify tables

In the previous article (cursors overview) we have seen simple examples with SQL statements. You can also use cursor to modify database tables. If we want to use explicit cursor to update or delete data, we need to: -declare the cursor with FOR UPDATE clause (to avoid unwanted changes from others). -use clause WHERE CURRENT OF to modify...

Read More