Hello,
I am getting the shown error for the following select statement.
select createDocument ('namespaceUri', 'qualifiedName', NULL) from dual;
ORA-06571: Function APPENDCHILD does not guarantee not to update database
createDoument is a stored function with the following code:
CREATE OR REPLACE FUNCTION createDocumentType (arg_qualifiedName VARCHAR, arg_publicId VARCHAR, arg_systemId VARCHAR) RETURN NUMBER IS
DOCUMENT_TYPE_NODE_TYPE_ID CONSTANT NUMBER := 10;
newDocumentTypeId NUMBER;
BEGIN
newDocumentTypeId := createNode (NULL, DOCUMENT_TYPE_NODE_TYPE_ID);
INSERT INTO t_DocumentType ( id, name, publicId, systemId, internalSubset)
VALUES (newDocumentTypeId, arg_qualifiedName, arg_publicId, arg_systemId, NULL);
RETURN newDocumentTypeId;
END createDocumentType;
Regards.
I am getting the shown error for the following select statement.
select createDocument ('namespaceUri', 'qualifiedName', NULL) from dual;
ORA-06571: Function APPENDCHILD does not guarantee not to update database
createDoument is a stored function with the following code:
CREATE OR REPLACE FUNCTION createDocumentType (arg_qualifiedName VARCHAR, arg_publicId VARCHAR, arg_systemId VARCHAR) RETURN NUMBER IS
DOCUMENT_TYPE_NODE_TYPE_ID CONSTANT NUMBER := 10;
newDocumentTypeId NUMBER;
BEGIN
newDocumentTypeId := createNode (NULL, DOCUMENT_TYPE_NODE_TYPE_ID);
INSERT INTO t_DocumentType ( id, name, publicId, systemId, internalSubset)
VALUES (newDocumentTypeId, arg_qualifiedName, arg_publicId, arg_systemId, NULL);
RETURN newDocumentTypeId;
END createDocumentType;
Regards.