The GETSTRINGVAL member function returns a document as a string. The function returns a string containing a serialized XML representation, or returns the text itself in case of a text node. If the length of the VARCHAR2 column in the XML document exceeds the maximum size allowed, which is 4,000 characters, an error occurs at runtime.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
MEMBER FUNCTION getStringVal()
RETURN VARCHAR2;