Re: why can't I insert long string into CLOB field?
| From: | thies at digicol dot de | Date: | Wed, 30 Aug 2000 09:53:28 +0000 |
| Subject: | Re: why can't I insert long string into CLOB field? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2474@lists.php.net to get a copy of this message | ||
you have to use the oci*() calls - the ora_() calls do not
support CLOBs.
how to do it -> see attached sample code.
tc
On Wed, Aug 30, 2000 at 04:29:16PM +0800, Fred Cai wrote:
> evironment: PHP4 + oracle8
>
> I have a table which have a CLOB field,
> when I insert a string about 4k length into the CLOB field in PHP, there is
> a error;
>
> The SQL statement:
> insert into table_name values (..., long_string ,...);
>
>
> "Warning: Ora_Parse failed (ORA-01704: the string is too long -- while
> processing OCI function OPARSE) in ./db/oracle.php on line 110"
>
> Why? and how to solve it?
> Who could tell me?
> I'll be very thankful,:-)
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!"
Digital Collections Phone +49 40 235350 Fax +49 40 23535180
Hammerbrookstr. 93 20097 Hamburg / Germany
Attachment: [application/x-tar-gz] blobs.tgz
Attachment: [application/x-tar-gz] blobs.tgz