Table T1 was created with the following command: CREATE TABLE t1 (c1 XML)
A stored procedure is required that takes two input parameters: PARM1 (XML data type) PARM2 (VARCHAR(32000) data type) and performs the following actions:
1. Checks to see if the value of the ITEM element of the document passed in as PARM1 is less than 200 - if so, inserts the value of PARM1 into column C1 of table T1
2. Inserts the value of PARM2 into column C1 of table T1
Which of the following SQL statements will create such a procedure?
-
A
CREATE PROCEDURE proc1(IN parm1 XML, IN parm2 VARCHAR(32000))
LANGUAGE SQL
BEGIN
DECLARE var1 XML;
IF(XMLEXISTS($x/ITEM[value < 200] passing by ref parm1 as "x" )) THEN
INSERT INTO t1 VALUES(parm1);
ELSE
SET var1 = XMLCAST(parm2);
INSERT INTO t1 VALUES(var1);
END -
B
CREATE PROCEDURE proc1(IN parm1 XML, IN parm2 VARCHAR(32000))
LANGUAGE SQL
BEGIN
DECLARE var1 XML;
IF(XMLEXISTS($x/ITEM[value < 200] passing by ref parm1 as "x" )) THEN
INSERT INTO t1 VALUES(parm1);
END IF;
SET var1 = XMLCAST(parm2);
INSERT INTO t1 VALUES(var1);
END -
C
CREATE PROCEDURE proc1(IN parm1 XML, IN parm2 VARCHAR(32000))
LANGUAGE SQL
BEGIN
SET var1 XML;
IF(XMLEXISTS($x/ITEM[value < 200] passing by ref parm1 as "x" )) THEN
INSERT INTO t1 VALUES(parm1);
END IF;
var1 = XMLPARSE(document parm2 preserve whitespace);
INSERT INTO t1 VALUES(var1);
END -
D
CREATE PROCEDURE proc1(IN parm1 XML, IN parm2 VARCHAR(32000))
LANGUAGE SQL
BEGIN
DECLARE var1 XML;
IF(XMLEXISTS($x/ITEM[value < 200] passing by ref parm1 as "x" )) THEN
INSERT INTO t1 VALUES(parm1);
END IF;
SET var1 = XMLPARSE(document parm2 preserve whitespace);
INSERT INTO t1 VALUES(var1);
END