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: Why does a procedure with more than 1000 chars fail?

Re: Why does a procedure with more than 1000 chars fail?

From: Diane <Diane_at_coalole.demon.co.uk>
Date: Tue, 29 Dec 1998 21:02:30 +0000
Message-ID: <85+04DAmNUi2IwNu@coalole.demon.co.uk>


In article <769d4v$knd$1_at_nnrp1.dejanews.com>, chandus_at_rocketmail.com writes
>Hi folks,
>
>whenever a procedure with statement length > 1000 is executed, it fails with
>an oracle error
>- Inserted value too long for the column.
>
>I checked the v$session, v$sql and v$sqlarea. I observed an interesting twist.
>First of all, v$sql has a column SQL_TEXT which is varchar2(1000). Any sql
>statement more than 1000 characters is split into multiple lines and parsed.
>This is applicable for direct select, update, insert and delete statements.
>
>When I checked in v$sql for my packaged procedure, it showed like this.
>"begin <pkg_name>.<procedure_name>(arg1 => :001, arg2 => 002 .....)"
>
>The no of arguments in my packaged procedure is about 30, most of them of type
>varchar2. And I also expect the length of the statement "begin ...; end;"
>to be above 1000 characters
>
>Is there any fix for this problem? Is there anything I should do?
>
>TIA,
>Chandu
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
I think you can put carrige returns (newlines) in to make individual lines less than 1000 characters which should fix the problem but I'm not really a PL?SQL expert
--
Diane Received on Tue Dec 29 1998 - 15:02:30 CST

Original text of this message

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