Re: Bug #690 Updated:

> ID: 690 > Updated by: kara > Reported By: voelkl@fmi.uni-passau.de > 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@lists.php.net For help: php-dev-help@lists.php.net