ADOStoredProc and Oracle BLOB
- From: "Urmas Siitan" <urmas@xxxxxxxxxx>
- Date: Wed, 5 Dec 2007 16:28:13 +0200
Hi,
I have a following problem:
There is Oracle procedure with paramater of type BLOB. I use TADOStoredProc
where I create parameter like this:
Parameters.CreateParameter('file_data_', ftBlob, pdInput, 100000000,
'');
and assign value to it like this:
Parameters.ParamByName('file_data_').LoadFromFile(FullFName, ftBlob);
Everything works fine until the file size is <32K. For larger files I get an
error ORA-01460.
Which gives me a feeling that BLOB size is limited to 32K :)
Does anybody know how to change it?
TIA
Urmas
.
- Prev by Date: HELP!!! - Urgent assistance is needed
- Next by Date: Re: HELP!!! - Urgent assistance is needed
- Previous by thread: HELP!!! - Urgent assistance is needed
- Next by thread: Literal fields in SQL with ADO and ODBC yield Access Violation
- Index(es):