View Single Post

  #4 (permalink)  
Old 01-23-2004
Steve Holdoway
 
Posts: n/a
Default Re: Running PL/SQL scripts from PHP

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
Reply With Quote