Oracle.plsql java class

From: SICA <i19640_at_caravela.di.fc.ul.pt>
Date: 1998/04/20
Message-ID: <Pine.LNX.3.95.980420150244.18088A-100000_at_caravela.di.fc.ul.pt>#1/1


        Hello!!

        I want to pass 4000 chars from plsql to java using PStringBuffer from Oracle.plsql class but it only works if I declare PStringBuffer(2000) which isn't enough to hold 4000 chars.

         I read some documentation about Oracle.plsql class and it said that PStringBuffer is used to retrieve varchar2 and long plsql types. If it is used for long plsql type than it should support 2 gigabytes and not only 2000 chars.

        Thanks in advance.  

         _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
        _/                                                              _/
       _/               Sofia Isabel da Cruz Alves                     _/
      _/        Faculdade de Ciencias - Universidade de Lisboa        _/
     _/                 Departamento de Informatica                  _/
    _/              E-MAIL: i19640_at_caravela.di.fc.ul.pt             _/
   _/                                                              _/
  _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Received on Mon Apr 20 1998 - 00:00:00 CEST

Original text of this message