Answered

PostgreSQL and MySQL

Anonymous 8 years ago • updated by 8 years ago • 8

Hello,

I have a question regarding PostgreSQL and MySQL. I have a database in MySQL for now and a stored procedure to insert data. Despite the fact everything is good, and user have authenticated access over procedure, Warewolf seems cannot list the procedure.

Here are the details of procedure:

DELIMITER $$
CREATE PROCEDURE rfidautomatic_INSERT(IN uid varchar(45))
BEGIN
insert into webtest.rfid_uid (rfiduid) values (uid);
END
DELIMITER ;

tool

Vote

Replies 8
Oldest first
- Newest first
- Oldest first

Under review

8 years ago

Hello,

Note that the DELIMITER keyword is a function of the command line mysql client (and some other clients) only and not a regular MySQL language feature. It won't work if you tried to pass it through a programming language API to MySQL, which is how Warewolf works.

Reply
- Is it?
- Inappropriate
- Spam
- Duplicate
|

8 years ago

We are looking into why it would not show up in the Action list.
What version of MySQL are you using.
What version of Warewolf are you running?

Reply
- Is it?
- Inappropriate
- Spam
- Duplicate
|

8 years ago

Hi,

Please confirm that the procedure is actually created in mySQL based on the script you provided will not run as it is missing a $$ on the 'END' line.

The procedure also looks like a duplicate of the one in the following post:

http://community.warewolf.io/topics/368-parameter-warewolf-variable-not-found-in-the-collection

In the post above the procedure is showing in the list however not executing, we are busy with the executing issue and it will be resolved in the next release.

Thanks