Skip to Main Content
Forums

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!

reading number string with command and decimal

aliyesami-JavaNetJun 12 2019 — edited Jun 13 2019

how can i read a text string  like "31,432.99"  as number 31432.99 ?

i tried using NLS_NUMERIC_CHARACTERS  but it reads the strings with comma properly but does not read if i put the

decimal point.

thanks

alter session  set NLS_NUMERIC_CHARACTERS= '.,';

Comments

Check if your Windows temp is not full.
Test the Database connection(SYS) from local or from the same machine where you are installing FMW.
Test the DB connection on FMW machine using SQL*plus and SQL Developer. If you do not have SQL*plus, install the instant client to test the Database connection https://www.oracle.com/database/technologies/instant-client/downloads.html
Check for the DB alert/listener logs if the connection from RCU is made to the Database.
If nothing works, enable SQL*Net tracing and check what is happening post you give DB credentials in RCU.
Thanks, Suresh

SANPAT

Dear Suresh,
Checked all your given 5 points, but didn't find any problem, even able to login.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ppn)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date 29-NOV-2021 10:28:50
Uptime 0 days 0 hr. 35 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\App\Oracle19c\network\admin\listener.ora
Listener Log File C:\App\Oracle\diag\tnslsnr\ppn\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ppn.primepak.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ppn.primepak.com)(PORT=5500))(Security=(my_wallet_directory=C:\APP\ORACLE\admin\ppn\xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ppn" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
Service "ppnXDB" has 1 instance(s).
Instance "ppn", status READY, has 1 handler(s) for this service...
The command completed successfully

SQL> SELECT name,VALUE FROM V$DIAG_INFO where name = 'Diag Alert';
NAME--------------------------------------------------------------
VALUE--------------------------------------------------------------------------------
Diag Alert
C:\APP\ORACLE\diag\rdbms\ppn\ppn\alert

sanjay

Moving this thread to a more appropriate area. Posting in "Forms" was not the right place for this issue.

1 - 3

Post Details

Added on Jun 12 2019
#plsql, #sql-developer
7 comments
1,035 views