Skip to Main Content

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!

Add Arabic Text

user8942603Jan 31 2010 — edited Jan 31 2010
Dear All

I have Table
CREATE TABLE MASAR.MSR_TEXT_TEST
(
ARABIC_DESCRIPTION VARCHAR2(1000 BYTE),
TEXT_ID NUMBER
)

when execute Procdure by add p_ar_text =' قال أبو عُبيد القاسم بن سلاّم : زرت الإِمام أَحْمد - بن حنبل - ، فلما دخلت قام فاعْتَنَقني وأَجْلَسَني في صَدْر مَجْلِسه';

The Error Occured:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8

Please Note that I have Oracle 10g database.

Edited by: user8942603 on 31/01/2010 04:52 ص
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2010
Added on Jan 31 2010
2 comments
631 views