Re: DBMS_LOB and PLSQL

Gary Menchen wrote:

> I believe that the most you can pass from a web page using the htp
> package, is 32K, the maximum size of a varchar2.
>
> It is possible to upload files from the client desktop into a blob,
> using a file upload form. It requires some configuration on the server.

I'm not sure if you are correct though you may be.

The GET_PAGE procedure has an OUT parameter ... THEPAGE that is a TABLE OF VARCHAR2(256). Which is analogous to how DBMS_SQL handles strings larger than 32K.

I'd be interested in whether anyone knows if that is how this works.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)