SQL & PL/SQL :: Oracle 9i DB - Developer Suite And Character Set
Feb 20, 2012
I am running an Oracle 9i DB with character set : FRENCH_FRANCE.WE8ISO8859P1.
The data inside the DB deals with two languages :
- French and Arabic.
I insert, delete, update data on the DB through one of these tools :
- SQL*PLUS
- Forms 6i
and everything works fine especially with Arabic : characters are interpreted correctly by these tools. Now, I want to use Dev Suite as a new tool.
My problem is with Arabic characters : they are not displayed correctly. On the web form (run by a JRE : JInitiator) the characters are not replaced by "?", they are wrongly interpreted.
Example :
The right interpretation of "Amine" in arabic is : أمين and not : Ããíä.
So, querying a table with Dev Suite returns me Ããíä and not ????.
It seems like the JRE "understands" the characters but doesn't know how to "interpret" the Arabic characters correctly. I've tried to play with the NLS_LANG parameter on the regedit but in vain.
I just upgraded our server to Oracle Fusion Middleware 11g with Forms and Reports and now I want to update the developers workstation too.
They have Oracle Developer Suite 10g R1 for the moment. The last version of Oracle Developer Suite is 10g R2 and I don't see anything for 11g. All I can find is that it's now in Fusion Middleware 11g and JDeveloper... But, from what I can see, JDeveloper is for Java development, not for Forms/Reports development.
So, do I need to use Oracle Developer Suite 10g R2 or is there a new version of it?
i am in middle of the installation process. installor is not recognising the second one.
i gave the path to the second file. I tried from the disk by writing the file to the disk. but of no use.how do i complete this installation process.
Unable to find the product files specified by the disk labled 'OracleDEVsuite'. Unable to continue installation , please check the value specified in variable FROM_CD_LABEL matches with the value in file disk.label or check if the disk is accessable.
i havn't find any location or relevent info in ht edisk.label file.
While installing Dev Suite 10g i got the following error:[URL] What should i do? I specified another oracle home name, i have oracle database 11g installed too, and i'm installing dev suite 10g on another location.
Am installed oracle 9i database and Oracle Developer Suite 10g.Am unable to run the Form. When I run the Application Local machine,Blank White Screen Appears No Error Message.Am installed
1.database in F: and Developer Suite in E :
2.I.E 6.0 and 1.31.1.28 J Initiator Version
Am started oc4j instance started.. in run time edit preferences both [URL] and [URL] are given
3. in formsweb.cfg i changed baseHTMLjinitiator=basejpi.htm
When I try to install "Oracle Developer Suite 10g 10.1.2.0.2" on Windows 7, I'm getting error , " Install has encountered an error while attempting to verify your virtual memory settings. verify that the sum of the initial sizes of the paging files is atleast 256 MB."
i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890.
i installed oracle 10g dev suite do i still need to install the db 10g? i tried installing db10g first then the dev suite. On the db 10g i can connect via sqlplus. while i cannot connect on the dev suite, which has a 'sqlplus' too.
i am trying the hr:hr credentials, also tried sys as sysdba it gives me tns protocol adapter error (12560)
i tried to replace the tnsnames.ora of the devsuite with the tnsnames.ora of db10g still didn't work. i also set up the ORACLE_HOME to the db 10g's folder
D:ProgramsOracleproduct10.2.0db_1
why does the devsuite has its own tnsnames.ora. does it have some db server of its own? if it has do i still need to install db 10g?
I dont know why, but my PL SQL Developer keeps changing special character as "ã", or "ç", to "?". And As I use these letters because of my language, I need a way to solve this thing.
how do we know database character set is either single character set or multi character set?
While changing character-set from AL32UTF8 to WE8MSWIN1252 got "ORA-12712: new character set must be a superset of old character set".
Below are steps taken to resolve the issue -
ALTER DATABASE CHARACTER SET WE8MSWIN1252;
i got this error: ORA-12712: new character set must be a superset of old character set
below are the commands executed by me:
SQL> SHUTDOWN IMMEDIATE; SQL> CONNECT SYS/password AS SYSDBA; SQL> STARTUP MOUNT; SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE WE8MSWIN1252; SQL> SHUTDOWN; SQL> STARTUP; SQL> QUIT;
And its working...
I have not done it in proper order. Neither have done ccsscan. Still, no user reported any issues. Do my changes truncated the data?
I have installed oracle form developer10g. without installing the oracle database. Oracle developer 10g can run independently.
I get the Error TNS: Protocol Adapter Error
My listener has the following: # listener.ora Network Configuration File: D:DevSuiteHome_2NETWORKADMINlistener.ora # Generated by Oracle configuration tools.
I am using oracle developer 10g R2. Now i would like to create a java(jar) function or any other type then would like to add this jar file into my oracle form with a button and when i run this and click on this button then display the message from java function.
How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?
I took the course for "Oracle Reports Developer 10g" but I didn't copy the schema when I took the course.
Now,I have the book "Oracle Reports Developer 10g: Build Reports Student Guide" but I look over the internet and I can't find the schema for this course. I needed the schemas for the following tables:
My company has acquired a technology that was written in Oracle Forms 6-8 and am looking to first compile and maintain and then upgrade to either 11g or another platform. The older versions of Oracle Development cannot be downloaded from Oracle's site. Will Oracle provide the link if asked?
I'm trying to insert a character from the extended ascii character set. Specifically, there's a company that has an accented e (�) in the name. Right now, the company name doesn't have the e at all, accent or no accent. So I'm trying to do an update, something like
update table1 set company_name='blah�" where company='blah'
It runs, but doesn't do the update. Even when I try to forcefully do an insert (instead of an update) I get nowhere; the accented is simply dropped. So the basic question is, how do you insert extended ascii characters into oracle?
I am using C++ OCI LIB, to insert some report data from remote OCI client to oracle 11 server. This data is read by another process to create the report.The DB CHARSET is UTF-8. But the report tool expects the data to be ISO08859-1 encoded. So while inserting the data into the database i specify the following LANG and CHARSET for my table colulmn in client:
The TARGET DB CHARSET is UTF-8 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 size_t csid = 871; // UTF-8 OCIAtrSet((void *) bnd1p, (ub4) OCI_HTYPE_BIND, *(void *)&csid*, (ub4) 0, (ub4)OCI_ATTR_CHARSET_ID, errhp);
This solution works for almost every case of ASCII and Extended ASCII Charest but we are facing issues if we have few specific characters to be inserted.f we are trying to insert single beta character [β] through client, the data goes empty to the column.
Beta Character details: DEC OCT HEX BIN Symbol Description 223 337 DF 11011111 ß Latin small letter sharp s - ess-zed
DB Output after insert single β: select rawtohex(NAME) from PERSONS where EID=333;
RAWTOHEX(NAME) ---------------------------
But if the string is *"ββ"* everything work fine: DB Output for "ββ": select rawtohex(NAME) from PERSONS where EID=333;
I tried to debug the procedure in Oracle SQL Developer and got the below error,
Connecting to the database TEST. Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '****', '4000' ) ORA-30683: failure establishing connection to debugger ORA-12535: TNS:operation timed out ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68 ORA-06512: at line 1 Process exited. Disconnecting from the database TEST.
Here,
TEST is my database name, **** is IP address of my local machine 4000 is the port number, also I have set the debug port range as 4000 - 4999 in SQL DEVELOPER. firewall is not enabled in my machine.
