Solved

how eliminate character special in PL/SQL

Posted on 2007-03-27
2
1,819 Views
Last Modified: 2012-08-13
i have this problem, i receive from java aplication a input parameter with character special non printable.

How do i to eliminate this characters in PL/SQL

regards

Gerid Garcia
0
Comment
Question by:yerai
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
ravindran_eee earned 500 total points
ID: 18804998
Hi,

Use the below Oracle function..

create or replace function remove_special_chars (i_input varchar2)
return varchar as
l_temp varchar2(100);
o_output varchar2(100);
i number;
begin
for i in 1..length(i_input)
loop
select substr(i_input,i,1) into l_temp from dual;
if ascii(l_temp) >= 32 or ascii(l_temp) <= 126 then
o_output := o_output || l_temp;
end if;
end loop;
return o_output;
end remove_special_chars;
/

Thanks,
Ravindran
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question