Re: SQL statement > 32Kb
Date: 1995/11/08
Message-ID: <47qkqo$rph_at_maverick.tad.eds.com>#1/1
In article <470gd7$cab_at_altrade.nijmegen.inter.nl.net>,
W.van.der.Deijl_at_inter.nl.net says...
!
!Hi,
!
!We are developing some packages that are being used in some PL/SQL
!procedures. One of these packages contains about 5 procedures. But all
!of these procedures containts some large select-statements.
!
!When I create the package body (using a script) the create package
!body statement is larger then 32Kb, which causes:
!TNS packet writer failure
!No longer connected to Oracle
!
!when I exzecute the script from SQL*Plus.
!
!There might be to solutions:
!1) Make some buffer larger so that the statement may exceed 32Kb. But
!I don't know if this is possible and if it is, how I can do this....
!
!2) Create the package and add some procedures to it with separate
!statements. This way not all the code is included in one CREATE
!PACKAGE-statement. But I have looked in all the manuals and found no
!way to add a procedure to a package, then to create all of the package
!again (using one very large CREATE PACKAGE-statement)
!
!Doe anyone have the answer to this problem?
!Thanks!
!
A workaround that we've used is to ftp the "create package ..." statement to the server. Then run the statement on the server using SQL*DBA or SQL*Plus. Received on Wed Nov 08 1995 - 00:00:00 CET