| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
A copy of this was sent to chandus_at_rocketmail.com
(if that email address didn't require changing)
On Tue, 29 Dec 1998 02:01:03 GMT, you wrote:
>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?
>
Does the procedure you are running have an INSERT statement in it? Is it doing an insert? As the error says -- its an error during an INSERT. I do not believe it has anything to do with the length of the pl/sql block itself but rather some insert the pl/sql code is doing.
Lets see the block of code and the entire error message stack from Oracle...
>TIA,
>Chandu
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Dec 30 1998 - 08:19:16 CST
 |
 |