Executing an Oracle procedure using PHP - possible?

Question

I'm trying to run a very simple Oracle procedure from PHP, using the following statement:

$sql = 'exec procedureName(param1, param2)';
$sql = oci_parse($connection, $sql); oci_execute($sql);

Running this in Oracle SQL developer returns a successful 'anonymous block completed' message, but running this via PHP returns an 'ORA-00900: invalid SQL statement' error.

Is there anyway to run this procedure from PHP? Many thanks

Try getting rid of "exec " in $sql.

Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні

2012-04-18 15:35:52 +00:00
Commented Apr 18, 2012 at 15:35 — Bob Jarvis - Слава Україні
– Bob Jarvis - Слава Україні, Commented Apr 18, 2012 at 15:35
Many thanks, good suggestion but I'm getting the same error

Nick
– Nick

2012-04-18 15:41:29 +00:00
Commented Apr 18, 2012 at 15:41 — Nick
– Nick, Commented Apr 18, 2012 at 15:41

Bob Jarvis - Слава Україні · Accepted Answer · 2012-04-18 15:48:05Z

6

Looking a little deeper, I think you'll need to put your procedure call inside a PL/SQL BEGIN-END pair, as in:

$sql = 'BEGIN procedureName(:param1, :param2); END;';
$stmt_id = oci_parse($connection, $sql);
oci_bind_by_name($stmt_id, ':param1', $value1);
oci_bind_by_name($stmt_id, ':param2', $value2);
oci_execute($stmt_id);

You'll need to edit the above to use whatever variable names are appropriate in the calls to oci_bind_by_name.

Also note that the presence of semi-colons in the SQL string is important.

Share and enjoy.

edited Apr 18, 2012 at 15:48

answered Apr 18, 2012 at 15:42

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MsMe · Accepted Answer · 2018-03-08 07:12:32Z

0

$sql = 'BEGIN procedureName(:param1, :param2); END;';
$stmt_id = oci_parse($connection, $sql);
oci_execute($stmt_id);

answered Mar 8, 2018 at 7:12

MsMe

1

Collectives™ on Stack Overflow

Executing an Oracle procedure using PHP - possible?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related