X-Received: by 10.224.200.202 with SMTP id ex10mr21760446qab.8.1370543005572;
        Thu, 06 Jun 2013 11:23:25 -0700 (PDT)
X-Received: by 10.49.4.39 with SMTP id h7mr2863808qeh.2.1370543005412; Thu, 06
 Jun 2013 11:23:25 -0700 (PDT)
Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.85.216.88.MISMATCH!ch1no2720294qab.0!news-out.google.com!10ni1106qax.0!nntp.google.com!ch1no2720292qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Thu, 6 Jun 2013 11:23:25 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=208.65.116.5; posting-account=QIrL2QoAAADrbn6JOMuPXQbWYp5Y42ky
NNTP-Posting-Host: 208.65.116.5
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9801fafd-844a-49f0-be3b-397f0e96e9c6@googlegroups.com>
Subject: Passing parameter > 32k
From: artmerar@gmail.com
Injection-Date: Thu, 06 Jun 2013 18:23:25 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref:  news.cambrium.nl


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!