Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why does a procedure with more than 1000 chars fail?
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