Re: How to handle a long strings in a pl sql stored procedure,
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: Tue, 19 Aug 2003 05:48:53 -0400
Message-ID: <3259489.1061286533_at_dbforums.com>
Date: Tue, 19 Aug 2003 05:48:53 -0400
Message-ID: <3259489.1061286533_at_dbforums.com>
Originally posted by Abacnet
> Hi gurus,
>
> I have a # separated string that can be greater than 4000 chars in
> length. Here is an example : abababa#2121212#vbvbvbv
> I need to get each token in a loop, in a pl sql stored procedure. That
> means I need to pass the string as a parameter, in the stored
> procedure and to get abababa, 2121212 and vbvbvbv. I guess I cannot
> use Varchar2 since a Varchar2 cannot be greater than 4000 chars. I
> really a working sample for that.
>
> Thanks,
Read up on Oracle datatypes at http://tahiti.oracle.com.
- You can store upto 32767 bytes of data in a PLSQL VARCHAR2 variable.
- You can ONLY store upto 4000 bytes in a VARCHAR2 type database column.
Regards
/Rauf Sarwar
-- Posted via http://dbforums.comReceived on Tue Aug 19 2003 - 11:48:53 CEST