PHP oci_execute for Multiple Statements

Question

I'm trying to issue multiple INSERT statements within a single oci_execute() call on PHP. The problem is that I get this error:

ORA-00911: invalid character

I'm guessing it's the ; after each statement.

So now, my question is how do I make multiple INSERT statements that would work within oci_execute()?

Here's my query so far:

INSERT INTO tbl (id, name) VALUES(1, 'John');
INSERT INTO tbl (id, name) VALUES(2, 'Martha');
INSERT INTO tbl (id, name) VALUES(3, 'Richard')

EDIT:

Note that there is no ; at the end of my query because I'm using SQL statements.

Husqvik · Accepted Answer · 2015-11-26 19:55:05Z

7

Just wrap all statement into anonymous PL/SQL block:

BEGIN
    INSERT INTO tbl (id, name) VALUES(1, 'John');
    INSERT INTO tbl (id, name) VALUES(2, 'Martha');
    INSERT INTO tbl (id, name) VALUES(3, 'Richard');    
END;

Oracle doesn't support batch of commands. Anonymous PL/SQL block is executed as single command.

edited Nov 26, 2015 at 19:55

answered Nov 26, 2015 at 19:42

Husqvik

5,8191 gold badge23 silver badges32 bronze badges

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

1 Comment

dokgu Over a year ago

Thanks, it works! Mind explaining why I need to do it this way?

Collectives™ on Stack Overflow

PHP oci_execute for Multiple Statements

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related