SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

bigger than varchar2 datatype....

jp609096Oct 21 2009 — edited Oct 21 2009

hai everybody,

I have a problem with pl/sql varchar2 datattype....I created a small project in pl/sql(10gv2) and asp.net..In plsql procedure i have a varchar2 variable..but some time that variable may hold data beyond the limit of varchar2...hence the problem occurs...

so i request you to is there any datatype that substitute varchar2(without changing the functionality of the procedure/code) by just changing the datatype only..

Is there any suggetion..

regards,
john

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Oct 21 2009

13 comments

6,489 views