Some critical attributes, such as
are explicitly part of the storage format.
Other attributes, that also impact significantly the behavior in general of Stored Programs, can be implicitly derived from other properties of the storage layer. In particular:
USE <database> in effect for a
stored program is the
schema the stored
object belongs to.
DECLARE v CHAR(10) does not
intrinsically convey any notion of character set or
collation. The character set and collation of this local
variable, in a stored program, derives from the character
set and collation of the
stored object belongs to.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices