Re: sql*plus limits user variable length to 240

nekolim_at_gmail.com schrieb:
> Hi,
>
> I read that SQL*Plus has a limitation on the user's variable/parameter
> for the Stored Procedure to 240 characters. Is there anyway to increase
> this max length?
>
> I pass in a variable of type varchar2 from a Korn script through
> sql*plus. This variable is actually 1129 long. SQL*Plus throws an error
> that this is too long. Please advise if the SQL*Plus session can be set
> to have longer variable length.
>
> Thank you.

There are (at least) 2 Notes on Metalink regarding limitations of quoted strings (aka literals) - 1004514.6 and 1068616.6 . Workarounds are provided as well.

Best regards

Maxim Received on Mon Jul 04 2005 - 16:10:11 CEST