How to run a oracle sql file (*.sql) from php

Question

How to run oracle sql file from PHP using Adodb

winkbrace · Accepted Answer · 2010-12-16 14:48:06Z

1

If it's just a normal sql statement you could just read the file with file_get_contents and execute it.

$rs = $DB->Execute(file_get_contents('query.sql'));

answered Dec 16, 2010 at 14:48

winkbrace

2,70126 silver badges20 bronze badges

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

3 Comments

Is there any way to pass the filename to the Oracle client library? So that the library does the reading of it, instead of the caller doing it?

That wouldn't make sense, since the library needs to work everywhere, not only for your one script. :)

I don't think, you understood my question. What I'm looking for is some equivalent to $DB->ExecuteFile('query.sql')). Is there such a thing?