Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to parse SQL procedure CALL #70

Open
Delicious-Bacon opened this issue May 17, 2022 · 0 comments
Open

How to parse SQL procedure CALL #70

Delicious-Bacon opened this issue May 17, 2022 · 0 comments

Comments

@Delicious-Bacon
Copy link

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant