Hey everyone, please disregard this off-topic question.  I think I may
need some PHP knowledge too, but here goes.

In all of the documentation I've found, a DBA can write stored
procedures, functions and views.  I know how to write a stored procedure
to do INSERT, UPDATE or DELETE functions.  I really want to be able to
store queries in Oracle just as you would an INSERT.

For example, I want to have a SP do this:

SELECT  FLGT_NUMBER, DPTR_ARPT, ARVL_ARPT
FROM    FLIGHT
WHERE   FLGT_NUM = $flgt_num
ORDER BY        FLGT_NUM;

I need the entire recordset returned so that I can call the SP from PHP.
This almost sounds like making a view, but I don't know how to send
parameters to the view.

I really don't know a lot about Oracle and quite frankly the Oracle
documentation I've found sucks.

Can anyone help me?  Would anyone be so kind as to tell me what their
favorite Oracle resource is?  I've tried www.oracle.com and www.orafaq.com
but neither has helped me find what I'm looking for.  It's too bad Google
took over Deja; I can't post there.  My university's news server is far
from being called "maintained" and I have no other decent news server at
my disposal.

Pleading for help,


Brian Mauter
[EMAIL PROTECTED]



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to