You can use static cursors, or cursor variables. You must include the specification file directly in the source of your host application. You then include the specification for the module procedures or stubs in each application that calls module procedures or stubs using the with context clause. The generated procedures are not functions. The maximum dimension of an array is 32000 3.
Some languages require multi-byte character sets.
Also, countries have differing ways of punctuating numbers, and representing dates and currency symbols. It also lets your applications run in different language environments. With NLS, number and date formats adapt automatically to the language conventions specified for a user session. Thus, NLS allows users around the world to interact with Oracle in their native languages. You control the operation of language-dependent features by specifying various NLS parameters.