big files

[Anabolik]

I store the content of files using sql query "insert ...". With small
files all is ok. But I can not to insert big files into table. I have
error to increase the procedure cash. I did it, but it has no effect.
May be, there are many ways how to insert file to database. Can
someone give the solution?

[Rob V [Sybase]]

I think you need to provide some more details as to the problem you're
encountering.
Are you using text or image columns?
What error do you get?
What made you increase the size of the procedure cache?

-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:***@sypron.nl
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

Post by Anabolik
I store the content of files using sql query "insert ...". With small
files all is ok. But I can not to insert big files into table. I have
error to increase the procedure cash. I did it, but it has no effect.
May be, there are many ways how to insert file to database. Can
someone give the solution?

[ThanksButNo]

Post by Anabolik
I store the content of files using sql query "insert ...". With small
files all is ok. But I can not to insert big files into table. I have
error to increase the procedure cash. I did it, but it has no effect.
May be, there are many ways how to insert file to database. Can
someone give the solution?

Anabolik, you should not multi-post; defined as posting
more than one message to more than one group on the same
subject matter.

You now have created two distinct threads (that I know of)
on this same topic with slightly diverging answers.

comp.databases.sybase and sybase.public.ase.general

You should either post in exactly one newsgroup (preferred)
or do what's known as "cross-post", where it's exactly *ONE*
message posted in more than one group. That way, the thread
will be reflected in each group, and all the participants will
know what everyone else has already said.

\:-\