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]

Re: Running PL/SQL scripts from PHP

In news:bup1l1$t59 $1@woodrow.ucda vis.edu,
Dung Nguyen <dung@ucdavis.e du> typed:[color=blue]
> 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[/color]
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?sig=a5c08b22cb1d77702441fcc44bf8b50f

[Andy Hassall]

Re: Running PL/SQL scripts from PHP

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <dung@ucdavis.e du> wrote:
[color=blue]
>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?[/color]

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.andyhsoftwa re.co.uk/space>

[Steve Holdoway]

Re: Running PL/SQL scripts from PHP

On Thu, 22 Jan 2004 09:35:29 -0800, "Dung Nguyen" <dung@ucdavis.e du>
wrote:
[color=blue]
>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
>[/color]
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