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!

Handling PL/SQL variable text more than 32k characters

781255Jun 24 2010 — edited Jun 24 2010

Hi,

I have developed PL/sql Program to perform a query and then fetch the records into VARCHAR2(32767) variable and send an email to specific group of people but I'm getting an error because query contains 8 columns and returns more than 300 rows so I'm getting an exception error saying value error: buffer too small.

I realized that I need to declare the v_abc to CLOB instead of VARCHAR2 and I tried that and it didn't reslove the issue. Is there anything I'm missing other than declaring it to CLOB variable ? Do I need to use DBMS_LOB package to do anything with my variable to display the text before sending the email out ?

Kindly let me know with an example of code so that I have an idea. I will look forward to hearing from you soon.

Thanks
Hiten

Edited by: user2210767 on Jun 24, 2010 7:40 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2010

Added on Jun 24 2010

#pl, #sql

9 comments

2,431 views