Unknown query: call update_oai()

Question

I am working on an old project and just saw a function:

$query = 'call update_oai()';
$res = $_DB->queryRaw($query);

I really can't find what is this query: "call update_oai". Any idea?

you can get at the contents of the stored procedure by `SHOW PROCEDURE CODE update_oai;` — Orangepill, May 29 '13 at 14:33
You can view a list of all procedures with `SHOW PROCEDURE STATUS`. — Ed Gibbs, May 29 '13 at 14:35
also if you want a list of the stored procedures on the database you can use `SHOW PROCEDURE STATUS` — Orangepill, May 29 '13 at 14:41

score 3 · Answer 1 · answered May 29 '13 at 14:32

3

CALL statement invokes a stored procedure, in your case the stored procedure with name update_oai.

Syntax:

CALL sp_name([parameter[,...]])

answered May 29 '13 at 14:32

bpoiss

score 1 · Accepted Answer · answered May 29 '13 at 14:32

1

This is probably a stored procedure, have a look in the stored procedures created for your database.

answered May 29 '13 at 14:32

Andre Lombaard

Thank you, how to find the stored procedures? – Milos Cuculovic May 29 '13 at 14:32
It all depends on the user interface you are using, for phpmyadmin have a look at http://stackoverflow.com/questions/6115573/how-do-i-view-my-stored-procedures-in-phpmyadmin – Andre Lombaard May 29 '13 at 14:39

score 1 · Answer 3 · answered May 29 '13 at 14:33

1

In PHP, the CALL is used to call the store procedures and the name of procedure is update_oai here that have no arguments.

So there is calling a store procedure.

answered May 29 '13 at 14:33

Code Lღver

score 1 · Answer 4 · answered May 29 '13 at 14:58

1

This is a store procedure in mysql, you can find procedure in phpmyadmin.

answered May 29 '13 at 14:58

Rakesh Singh

4 Answers4