Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Long Column Inserts via PL/SQL

Re: Long Column Inserts via PL/SQL

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Fri, 21 May 1999 09:15:24 +0200
Message-ID: <7i316j$et2$1@gatekeeper.ornano.kapt.com> 





John,



I don't know anything about Worksheet, but I had the same problem with perl
scripts. In fact, you'll have to use DBMS. There might be a doc for the
package you use to access the database. In this doc might be something about
using DBMS through this package.


DBMS consists in constructing the query piece by piece and to bind your
variables to SQL variables. It permit to exceed the 2000 chars.



Received on Fri May 21 1999 - 02:15:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US