[PHP-DEV] Re: Bug #690 Updated: From: Wolfgang Voelkl (voelkl <email protected>)
Date: 09/30/98

> ID: 690
> Updated by: kara
> Reported By: voelkl <email protected>
> Status: Assigned
> Bug Type: Oracle related
> Assigned To: kara
> Comments:
>
> Where is the blob column referenced? Could you give a complete example
> statement?
>
> Full Bug description available at: http://ca.php.net/bugs.php3?id=690
>

Hi !
Sorry for answering so lately, but I moved to France and there I have
still some trouble with the Internetacces!

Here is a simple exemple for my problem:
<HTML>
<HEAD>
  <TITLE>PHP3 - Oracle Demo</TITLE>
</HEAD>
<BODY>
 SELECT gif FROM bild WHERE kennung='zukowski';

<H3>Ergebnis:</H3>

<? PutEnv("ORACLE_BASE=/net/laboheme/export/ora01/app/oracle");
PutEnv("ORACLE_HOME=/net/laboheme/export/ora01/app/oracle/product/8.0.3");
PutEnv("ORAHOME=/home/bf/oracle");
PutEnv("ORACLE_TERM=xsun5");
PutEnv("ORACLE_SID=DBBF");
PutEnv("TWO_TASK=DBBF");

$conn = ora_logon("demo","demo");
$cursor = Ora_Open($conn);

$query = "SELECT text FROM blob WHERE kennung='zukowski'";
Ora_Parse($cursor, $query);
Ora_Exec($cursor);
Ora_fetch($cursor);

$col = ora_getColumn ($cursor, 0);

echo "COL: $col";

Ora_Close($cursor);
Ora_Logoff($conn);
?>

<HR>
</BODY>
</HTML>

----------------
----------------

The result is something like:
-------------
Warning: Ora_Exec failed (ORA-00932: inconsistent datatypes -- while
processing OCI function OEXEC/OEXN) in
/home/www/php-bf/DBBF-online/alltables.php3 on line 23

Warning: Ora_Fetch failed (ORA-01002: fetch out of sequence -- while
processing OCI function OFETCH/OFEN) in
/home/www/php-bf/DBBF-online/alltables.php3 on line 24
-------------

mmmhhhhhhhhh!?

Good luck !
It would be fine if this would work in the future!

Wolfgang 

---
Sent through Global Message Exchange - http://www.gmx.net

--
PHP Development Mailing List   http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe <email protected>
For help: php-dev-help <email protected>