Re: Oracle query returning values in sqlplus, but not php.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Upon further investigation, I've found that this was a permissions problem. 
In oracle, a user can see everybody's 'PACKAGE', but only their own 
'PACKAGE BODY'.

Lang

Lang Sharpe wrote:

> Hi all
> 
> Here is a test version of my script. It queries the data dictionary view
> ALL_SOURCE. In sqlplus it returns all souce code in the database. In php
> it returns no rows.
> 
> The only odd thing about it is that ALL_SOURCE.TYPE is VARCHAR2(12), and
> 'PACKAGE BODY' is twelve characters long. When I change 'PACKAGE BODY' to
> 'PACKAGE', it does return rows.
> 
> <?php
> error_reporting(E_ALL);
> $oradb = OCILogon('****','****','****');
> 
> $packageStmt = OCIParse($oradb,
>     "SELECT * FROM ALL_SOURCE WHERE TYPE = 'PACKAGE BODY'");
> OCIExecute($packageStmt);
> if(OCIFetchInto($packageStmt,$aLine,OCI_ASSOC)) {
>   echo "Cool Bananas\n";
>   var_dump($aLine);
> } else {
>   echo "No Bananas\n";
> }
> 
> OCILogoff($oradb);
> ?>
> 
> Im using PHP 4.3.2 Linked to Oracle 9.2.0.1.0 libraries connecting to
> oracle 9.2.0.1.0 database on another machine. Can someone confirm it is
> only me?
> 
> Lang


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux