ORA-01704: string literal too long AND PHP/PEAR
| From: | Roger Spears | Date: | Fri, 17 Oct 2003 19:38:39 +0000 |
| Subject: | ORA-01704: string literal too long AND PHP/PEAR | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31108@lists.php.net to get a copy of this message | ||
Ok all of you Oracle experts out there, I've had one heck of a day wrestling with this oracle stuff. My experience with Oracle is turning into a greek tragedy.....
I'm using PHP/PEAR to execute my queries on an oracle table. I'm trying to store very long pieces of text into a CLOB field. Currently I'm getting a string too long error.
I've googled to find that there are certain limits when inserting into a table. The CLOB datafield may hold 4 gigs of text, but you may only insert 4000 bytes at a time. Or at least that's how I understand it.
Anyone got a work around for this?
I've tried:
OCIBindByName($sql,":fieldName",&$myVariable, -1);
But I'm not sure I'm using it correctly with PEAR. In my code, I have my sql statement, then I do the OCIBindByName() call, then I do my insert.
But, this gets me:
ocibindbyname(): supplied argument is not a valid OCI8-Statement resource
Which is an actual PHP/PEAR error....I think...
Anyone out there have any work around suggestions? I really dont want to parse the insert statement into pieces each being less then 4000 bytes.
Thanks,
R