SQL & PL/SQL :: Arabic Language Appearing In A Different Format?

Mar 13, 2011

While generating reports, arabic languages are not exceuting in a normal format.

instead of سيبسيل its appearing as ÈãÇÚÒ íÊÎØÇÁ ÇáÔÇÑÚ æÇÕØÏãÉ æÊæÝÇÁ ÇáãÇÚÒ

[/bold]

1) we have done following changes at DB level.

CONN SYS/SYS@THAI AS SYSDBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;

[code]...

2) also installed regional Language.

View 10 Replies


ADVERTISEMENT

Forms :: Setup Arabic Language

Aug 8, 2010

My arabic data appears like ???????

How could I setup Arabic for forms , database?

I have 10G oracle database, forms,reports.

View 13 Replies View Related

Forms :: Change Language - English To Arabic

Apr 18, 2010

Which is changing language in form from English to Arabic and vise versa during run time when I validate from item to another one ..

View 5 Replies View Related

Server Administration :: Arabic Language Support

Apr 14, 2013

i installed database 10g with English language support and imported a dump file contains tables having columns in arabic

so after search i did these steps

SHUT;
CONN SYS/SYS AS SYSDBA
STARTUP RESTRICT;

Alter database character set INTERNAL_USE AR8ISO8859P6; (for arabic) which we want.

SHUT;
STARTUP

after the previous steps i checked on the nls_characterset from NLS_DATABASE_PARAMETERS and found it changed to AR8ISO8859P6 and that's right after that i can insert any arabic character to the tables but the original data still the same

is there anyway i can do to change the original data to be read in Arabic or i should make another import

View 1 Replies View Related

SQL & PL/SQL :: Transfer Data - Arabic Language Column Appears As Junk

Feb 8, 2012

When I transfer the data from Oracle to MS SQL I have one column in a table which is of Arabic Language.The data is fine in Oracle but when I transfer it to MS SQL Server I see that the text in MS SQL server appears as junk.

View 1 Replies View Related

PL/SQL :: Arabic Letters In Sqlplus Spool Output In CSV Format

Jul 4, 2013

I have 11.2.0.3 Db in HP UX 11.31, I have to spool a table output in csv format which contains arabic letters in few columns. my spool output is not showing the arabic letters properly.

[oratest@]$ echo $NLS_LANGAmerican_America.
AL32UTF8 V$NLS_PARAMETERS NLS_LANGUAGE                                                    
AMERICANNLS_TERRITORY  
AMERICANLS_CURRENCY                                                    
$NLS_ISO_CURRENCY                                                
AMERICANLS_NUMERIC_CHARACTERS                                          
.,NLS_CALENDAR                                                    

[Code]....

View 0 Replies View Related

SQL & PL/SQL :: 2nd Decimal Place Not Appearing?

Jul 19, 2012

I am using Oracle Forms 6i. In my program unit i write into a .CSV and .TXT File. Here if the amount is 100.00 then it prints as 100 only. That is if the 2nd decimal digit is 0 it doesnt print it.

For example
10.00 -->10
10.01--> 10.01
10.10-->10.1
10.12-->10.12

I used to_char(nvl(&amount,0),'9999999.99') so if query select to_char(nvl(10.10,0),'9999999.99') from dual, then i get the output as 10.10.

Do you think this is a problem with Oracle forms or SQL or the formatting of .TXT & .CSV.

View 12 Replies View Related

SQL & PL/SQL :: Comma Appearing In Place Of Dot

Jun 20, 2012

When I try to print a decimal value , I get the dot replaced with a comma.

SQL> select 23.45 from dual;

23.45
----------
23,45

Is it because of any particular sqlplus set command or OS issue?

View 3 Replies View Related

Forms :: Icons Not Appearing In 10g After Webutil Configuration On OAS

Mar 5, 2012

I want to open word document on client machine and to do this I have configured webutil and Its working fine. before configure the webutil icons are appearing on forms and after webutil icons are disappeared I have found that when I comment

baseHTMLjinitiator=webutiljpi.htm

icons appears but word document not open and the following error shows

oracle.forms.webutil.ole. Ole functions beans not found
CLIENT_OLE2.Create_Obj will not work.

View 6 Replies View Related

Performance Tuning :: Session Doing FTS Not Appearing In Longops?

Apr 4, 2012

dbo is a table with 1M records and structure similar to dba_objects

The following queries which does FTS, access same number of blocks as observed in v$session_longops

select * from dbo;
and
select * from dbo where object_type='VIEW';

Ex.
select * from dbo where object_type='VIEW';

select * from table(dbms_xplan.display_CURSOR(null,null,'ALLSTATS LAST'));

PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------------
------------------------------------------------------------------------------
SQL_ID 5mh418w9stax2, child number 0
-------------------------------------
select * from dbo where object_type in('VIEW')

Plan hash value: 2675347415

-------------------------------------------
| Id | Operation | Name | E-Rows |
-------------------------------------------
|* 1 | TABLE ACCESS FULL| DBO | 77611 |
-------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 - filter("OBJECT_TYPE"='VIEW')

I understand that because the query is accessing large number of blocks which exceeds 6 seconds threshold, the session appears in v$session_longops And this has nothing to do with the time spent in displaying the records on the screen

Now, why the following query does not appear in v$session_longops?

select /*+ full(dbo) */ count(*) from dbo;

select /*+ full(dbo) */ count(*) from dbo;

COUNT(*)
----------
1006525

Elapsed: 00:00:01.36
dv3_erie-dev_08 >select * from table(dbms_xplan.display_CURSOR(null,null,'ALLSTATS LAST'));

PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------
SQL_ID 4mgjwp3tv70db, child number 0
-------------------------------------
select /*+ full(dbo) */ count(*) from dbo

Plan hash value: 1423969929

--------------------------------------------
| Id | Operation | Name | E-Rows |
--------------------------------------------
| 1 | SORT AGGREGATE | | 1 |
| 2 | TABLE ACCESS FULL| DBO | 1007K|
--------------------------------------------

The table has all nullable columns and thus I assume the index on ID can't be used for this COUNT Thus ideally it shall be accessing same number of blocks and thus shall appear in v$session_longops

View 6 Replies View Related

Reports & Discoverer :: Output Not Appearing In Order When Running In Concurrent Program?

Jan 23, 2013

I have a problem. I have created a report that will list out details of checks using Report Builder. I use XML Publisher to register a template for the report. When running the program through concurrent request, the output will come in pdf format but are not in order.I have add 'Order By' statement in my sql scripts in report builder. Its working fine if test in report builder but not in concurrent program.

View 4 Replies View Related

Forms :: Displaying Arabic In 10g

Sep 15, 2009

1-i have exported a database 9i with character set WE8MSWIN1252 which is her original character set;
2- i have created a new database 10G R2 with character set AL32UTF8;
3- i have imported the .dmp file to this new database with imp.exe 9i version configured with WE8MSWIN1252 character set;

-The problem is:

* when i use sqlplus, arabic data displays correctly but, in forms 10G, arabic data displays lick this ?E?? EC???IEC...... HOW CAN I CONFIGURE FORMS TO DISPLAY CORRECTLY ARABIC DATA?

View 3 Replies View Related

SQL & PL/SQL :: Week On Particular Day According To Arabic Calendar

May 26, 2013

As my requirement is that to find week for particular date according to Arabic calender.As per Arabic calender first day for year starts from saturday.

so when i execute query :

select to_char(to_date('05/26/2013','MM/DD/RRRR'),'WW')
from dual;

Then it gives 21,but as per arabic calender it should show 22nd week.

getting result according to Arabic calender as it should return 22,because weak starts from saturday according to Arabic calender.

View 6 Replies View Related

Forms :: Arabic Characters?

Mar 17, 2010

problem is that when i call run_product to generate a report from a form i have the name of employee in arabic characters appear in wrong form. yet when i use query from forms directly or from reports directly. name appears correct.

i want the arabic charcters to appear correct when i call to show report from a form..

View 6 Replies View Related

Reports & Discoverer :: Report In Arabic PDF?

Oct 6, 2010

We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabicCharacters are not displaying Properly.

we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"

[code]...

View 3 Replies View Related

SQL & PL/SQL :: Change Arabic Characterset To English?

Jun 2, 2011

My client is using oracle 10 r2 on window 2003 server with arabic characterset WE8ISO8859P1. I am facing problem to understand the language specially in the case if any error occur it display me unknown characters.Is there any way to display it in English language??

I have also tried to change it in registry i.e changing NLS_LANG to AMERICAN_AMERICA.WE8ISO8859P1 but no success.Below are the parameters value of my database.also attach snapshot of sqlpromt.

PARAMETERVALUE
NLS_LANGUAGEAMERICAN
NLS_TERRITORYAMERICA
NLS_CURRENCY$

[code]...

View 1 Replies View Related

SQL & PL/SQL :: Sending Arabic Sms To Gsm From Oracle Database

Jun 16, 2013

i'm trying to send Arabic sms to mobile but the the message come in this way "?

View 29 Replies View Related

SQL & PL/SQL :: Converting Data From English To Arabic?

Feb 1, 2012

I need to prepare a bilingual system (English and Arabic).

So i need to store data in English as well as in Arabic

Is there any possibility to convert the data from English to Arabic and Arabic to English through oracle forms

basically what i am thinking is let us suppose user selected the English version of the application and he entered all the data in English during saving the records i need to convert all the English data into Arabic and store it in another table for Arabic data reference.

View 3 Replies View Related

SQL & PL/SQL :: Convert English Names To Arabic?

Apr 17, 2011

I need Code or Procedure which can convert English Names to Arabic Names in Oracle.

Like Given Student ID it fetch Student Name But I need to Convert this name to Arabic.

View 39 Replies View Related

Forms :: How To Use Some Fields Of Form In Arabic

Sep 30, 2012

i want to use Arabic language in one of the fields available on the form.

i alreade have done the following

1. On database

update PROPS$
set value$ ='AR8MSWIN1256'
where name = 'NLS_CHARACTERSET';

2. On system registry

Have changed all nls_lang variable in the registry to 'American_America.AR8MSWIN1256'

3. On Form

Have changed the field font to 'Simplified Arabic' and reading order 'right to left'

4. On Operating System

Change the region and language setting
format 'Arabic (saudi Arabia)'
keyboard and languages add 'Arabic (saudi arabia)'

5. have restarted the database on the server and also the client machine.

View 13 Replies View Related

Reports & Discoverer :: Garbage In Arabic PDF

Feb 6, 2012

I am generating a arabic report in Report Builder 6.0.8.11.3...It shows ok in report builder but when i generate PDF it shows garbage charachers.

NLS_Lang = ARABIC_SAUDI ARABIA.AR8MSWIN1256
report_path = c:windowfonts

in uifont.ali there are entries of fonts in PDF section.

View 5 Replies View Related

Forms :: Arabic Interface In Oracle From 10G?

Apr 5, 2010

I have a problem in oracle forms 10g, as a following: Arabic language show as special character for example(????,!!!!!!,....),I use now charcterset AMERICAN_AMERICA.WE8ISO8859P1 ,I cannot change this charcterset on my database Because I am afraid that the old data may be lost

Note: I am use now oracle form 6i without no problem in Arabic language and when I intended to converted to oracle form 10g ,the language problem has come back, and I was try to change nls_lang to several charcterset charcterset(Arabic_Egypt.AR8MSWIN1256 ,......) but still show in special character character like (????,!!!!!!,....)

View 5 Replies View Related

SQL & PL/SQL :: Restricting Other Language Characters?

Jan 24, 2011

I need to give validation for not allowing french or arabic or hindi alphabets or numbers except for only english alphanumeric letters.

I understood how to restrict special characters or spaces .

regexp_instr(i, '[^[:alnum:]]') = 0

This function allow only characters and numbers in English language and doesnt allow special characters.

I need to restrict further by not allowing any other language characters or numbers except only english alphanumeric letters.

View 37 Replies View Related

SQL & PL/SQL :: Oracle Procedure With C Language

Apr 16, 2010

My question is--> Is it possible to create procedure with embeded C code ?

View 10 Replies View Related

Reports & Discoverer :: Arabic Numbers In Report 11g?

Jan 21, 2012

I have a problem with arabic number in oracle report 11g. I made all the steps of 10g but it is still not working the characters(sentences in arabic are working fine) but number are not:

Steps:

1- Adding arabic fonts in uifont.ali file.

2- adding c:windowsfonts to Froms_path, Reports_path in Regedit

3- add parameter REPORTS_ARABIC_NUMBERAL IN regedit and making it's value CONTEXT.

View 5 Replies View Related

Forms :: Why Arabic Comma Reverse Text

Mar 2, 2012

The Text is displayed correctly when there is no "Arabic comma" ، , otherwise the text will be reversed, How can I avoid the issue, why we have such problem only when we add the comma. The screenshot: s10.postimage.org/8qw1l8621/Arabic_comma.png

View 3 Replies View Related

Reports & Discoverer :: Arabic Text Reading

Feb 23, 2012

I have below text stored in a DB table, am querying the same text in SQL Developer and am getting the correct reading order
Correct Data

Arabic : %بوليستر 70%, قطن 30
English : 70% Polyester, 30% Cotton

But in Oracle report am getting the wrong data like below

Wrong Data

Arabic : بوليستر 70%, قطن
30%

English : 30% Polyester 70% Cotton

View 6 Replies View Related

INSO Filter Language Support?

May 4, 2011

Is it possible to extract kannada text from a pdf document using INSO filter ?

Or Does it support only English Language ?

View 5 Replies View Related

Translating PL/SQL Into SQL 2000 Native Language?

Sep 14, 2007

I would need to translate the Oracle PL/SQL procedure to SQL Server 2000 SP4.

This is a package (body) that needs to be translated into a form that SQL server 2000 can unserstand it.

AS
FUNCTION object_name_fix (sobjectstring IN VARCHAR2)
RETURN VARCHAR2
AS

[Code].....

View 1 Replies View Related

Forms :: RTF Changes Not Shown For Specific Language

Mar 20, 2013

cookiemonster wrote on Wed, 20 March 2013 22:01Or if the user does anything to wipe the modified data - clear block, enter query etc - forms will also raise the alert.

i've uploaded a new RTF for Spanish but wen i login with the Spanish creds and run the program. Its not showing the changes i've chosen the right language and territory code.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved