I have an SQL procedure in MariaDB called bookUPDATE such as this:
BEGIN
UPDATE book
SET
book.Title= v_Title,
book.ReleaseDate = v_ReleaseDate,
book.Description = v_Description,
WHERE book.ID = v_ID;
END
I have an SQL builder for this procedure which creates a string:
q := "CALL bookUPDATE(?, ?, ?, ?); CALL bookUPDATE(?, ?, ?, ?);"
When I do the sqlparser.Parse(q) I get an error syntax error at position 5 near 'call'.
How am I supposed to Parse calling the procedure?
I have an SQL procedure in MariaDB called
bookUPDATEsuch as this:I have an SQL builder for this procedure which creates a string:
When I do the
sqlparser.Parse(q)I get an errorsyntax error at position 5 near 'call'.How am I supposed to Parse calling the procedure?