Oracle Stored Proc and PHP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Stored Proc and PHP

  1. #1
    Join Date
    Nov 2000
    Posts
    2
    <HEADS UP>
    This is not a pure Oracle Query. Thought I'd put it online here since I assumed some people on this board would also be working on PHP
    </HEADSUP>

    I am trying to get PHP to execute an Oracle Stored Procedure and then work with the returned values.

    If the proc returns just a single value i can work fine with the result, but if my proc returns multiple values (a whole row, multiple selects or multiple rows) i cannot work with the result obtained.

    Maybe, i am doing something wrong in writing the proc.. (though the proc works fine from the SQLPLUS prompt, does it have to be written differently to be called from PHP)

    Will be really obliged if somebody could help me with this.. I am a kind of newbie when it comes to ORACLE.. ( SYBASE and MSSQL are more in my line of work) so am having a REALLY BAD TIME with this.... :(

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    What interface are you using to Oracle? OCI, Ora, or ODBC? I know PHP has the OCI library calls and the ORA library calls, I think OCI is more of a standard. Have you tried the PHPLIB DB abstraction Layer? It might put the calls in more generic terms so you don't have to focus on Oracle as much. (Plus it's better application design).

  3. #3
    Join Date
    Dec 2000
    Posts
    32

    Arrow ORA Library

    Could anybody provide me some pointers for PHPLIB DB and ORA library ? I need to deal with capacity and consumption of Oracle database from VC++ application.

    Thanks.

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    You can get the libraries from [url]http://phplib.netuse.de/index.php3[/url]

    As for general questions you might want to hit the [url]http://www.phpbuilder.com[/url] forums as they're more geared twoard PHP. They have a PHP/Database forum.

    [Edited by pwoneill on 12-12-2000 at 04:34 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width