Why does a procedure with more than 1000 chars fail?

From: <chandus_at_rocketmail.com>
Date: Tue, 29 Dec 1998 02:01:03 GMT
Message-ID: <769d4v$knd$1@nnrp1.dejanews.com>

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 Received on Mon Dec 28 1998 - 20:01:03 CST