Running PL/SQL scripts from PHP

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

In news:bup1l1$t59$1@woodrow.ucdavis.edu,
Dung Nguyen <dung@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

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <dung@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 <andy@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <dung@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