Running PL/SQL scripts from PHP

[Dung Nguyen]

Hi.

Is there a way to execute PL/SQL scripts from PHP? I have PL/SQL scripts
that utilizes the DBMS_xxx packages. Is it possible to shell out a command
that will run the PL/SQL?

-DN

[-linux_lad]

In news:bu**********@woodrow.ucdavis.edu,
Dung Nguyen <du**@ucdavis.edu> typed:

Hi.

Is there a way to execute PL/SQL scripts from PHP? I have PL/SQL
scripts that utilizes the DBMS_xxx packages. Is it possible to shell
out a command that will run the PL/SQL?

-DN

Yes. Use the system function. Apache must have permission to run the script.

--
-linux_lad
To verify that this post isn't forged, click here:
http://www.spoofproof.org/verify.php...41fcc44bf8b50f

[Andy Hassall]

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <du**@ucdavis.edu> wrote:

Is there a way to execute PL/SQL scripts from PHP? I have PL/SQL scripts
that utilizes the DBMS_xxx packages. Is it possible to shell out a command
that will run the PL/SQL?

You'll have to define what you mean by 'PL/SQL script'.

Do you mean a PL/SQL block? Just use OCIParse/OCIExecute. There's an example
in the PHP manual.

Or do you mean you have a file containing one or more SQL and/or anonymous
PL/SQL blocks, which you'd normally run with SQL*Plus? And in particular, does
it use any SQL*Plus commands? (e.g. SET, or COLUMN). If so, shell out to
SQL*Plus with system() or exec() or backticks etc.

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

[Steve Holdoway]

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <du**@ucdavis.edu>
wrote:

Hi.

Is there a way to execute PL/SQL scripts from PHP? I have PL/SQL scripts
that utilizes the DBMS_xxx packages. Is it possible to shell out a command
that will run the PL/SQL?

-DN

You can compile php to have oracle oci calls incorporated. This works
for oracle 7 and 8, but I haven't tried it with oracle 9. Personally,
i'd build a package in the database, and then call the stored
procedures from the php... easier to maintain!

Steve