Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Passing parameter > 32k
71 views
Skip to first unread message
artm...@gmail.com
Jun 6, 2013, 2:23:25 PM6/6/13
to
Hi,
Our application is written in PHP and uses OCI and such to call stored procedures.
Aside from coding the insert statement in the PHP code, is there a way to call a stored procedure passing a parameter > 32k? What we are seeing is that anything < 32k is working fine. Once the parameter is > 32k, the procedure call does not work.
The receiving parameter type is a CLOB, but I believe this is a limitation on the application end. I was wondering if anyone had a way to pass > 32k to a stored procedure.
Thanks!
geos
Jun 6, 2013, 5:08:44 PM6/6/13
to
and oracle-related libraries but VB created empty clob on oracle side in
anonymous block, "retrieved it back" as bind variable to VB, filled it
with whatever > 32k, and passed to oracle procedure that had parameter
defined as clob. it works, but VB oracle-related stuff I used supports
passing clobs between VB and oracle. in my case clob was xml file larger
than 32k and I couldn't use varchar2 as a procedure parameter to sent it.
thanks,
geos
Mladen Gogala
Jun 7, 2013, 1:43:05 PM6/7/13
to
On Thu, 06 Jun 2013 23:08:44 +0200, geos wrote:
> On 2013-06-06 20:23, artm...@gmail.com wrote:
>>
>> Hi,
>>
>> Our application is written in PHP and uses OCI and such to call stored
>> procedures.
>>
>> Aside from coding the insert statement in the PHP code, is there a way
>> to call a stored procedure passing a parameter > 32k? What we are
>> seeing is that anything < 32k is working fine. Once the parameter is >
>> 32k, the procedure call does not work.
>>
>> The receiving parameter type is a CLOB, but I believe this is a
>> limitation on the application end. I was wondering if anyone had a way
>> to pass > 32k to a stored procedure.
>>
>> Thanks!
What is the parameter type? If the parameter type is VARCHAR2, it will
> On 2013-06-06 20:23, artm...@gmail.com wrote:
>>
>> Hi,
>>
>> Our application is written in PHP and uses OCI and such to call stored
>> procedures.
>>
>> Aside from coding the insert statement in the PHP code, is there a way
>> to call a stored procedure passing a parameter > 32k? What we are
>> seeing is that anything < 32k is working fine. Once the parameter is >
>> 32k, the procedure call does not work.
>>
>> The receiving parameter type is a CLOB, but I believe this is a
>> limitation on the application end. I was wondering if anyone had a way
>> to pass > 32k to a stored procedure.
>>
>> Thanks!
not work with anything larger than 32K. As for the PHP, I've never had
any problems with ADOdb, my favorite DB access framework:
http://phplens.com/lens/adodb/docs-oracle.htm
There is a book called Pro PHP Programming by Peter McIntyre, Brian
Danchilla and some other guy, which covers working with LOB types in the
Oracle database.
--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
0 new messages