|
|
Posted by Frank van Bortel on 03/02/06 22:32
marvado@hotmail.com wrote:
> Hi Dietmar,
>
> thanks for the tip, but I'm using exactly UTL_HTTP for that with htp.p
> and it doesn't seem to be showing back the php result.
> This is what I have in a plsql package:
>
> begin
> htp.p('phpinfo();');
> end;
>
> it gives me a blank page when I call the package from the browser. What
> I expect is to see the environment variables for PHP with the
> phpinfo(); function call.
>
> my setup:
> - oracle 9i
> - Oracle's HTTP Server with Apache 1.3
> - php 5
>
> anything I'm missing?
> thanks.
>
1) Your browser requests http://yourserver/plsql_dad/your_procedure
2) Apache by Oracle recognizes the plsql_dad bit, and hands the request
off to mod_plsql.
3) mod_plsql has some login processing, define in the Database
Access Descriptor (dad), but will eventually call your procedure.
4) Your procedure sends the string phpinfo(); back to mod_plsql, that
faithfully hands it off to Apache, that will send it back to your
browser.
5) Your browser does not understand phpinfo(); and displays a blank
page. Hint: check page source
What did *I* forget here? Do you understand the sequence of
events above? If you do, you should be able to understand why
you do not get what you expected.
Now, as we already established, I know nothing about php, but it
seems to me, that:
1) Your browser needs to send phpinfo(); (not *receive* it)
2) And it needs to be sent to the php environment, not the
Oracle pl/sql stack.
So, we're back at what was suggested before: link those two.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Navigation:
[Reply to this message]
|