Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-01722 in PL/SQL

Status
Not open for further replies.
tokerago13

tokerago13

Programmer
Jan 10, 2002
35
GB
() Aug 23, 2004
Hi All,
I trying to handle the error ora-01722 in a PL/Sql procedure. I have a columns with rows that have a mixture of varchar2 and number datatype. Originally the column is VARCHAR2. I'm looping through the column and assigning the value to a variable.
What I would like is to check that I only use columns with a numeric value and ignore every other value.
Is it possible to get a one liner, so that I don't have to handle the exception for alphernumeric values.
Thanks in advance.
Tony

 
Sort by date Sort by votes
Hi,
you might get some help if you asked this question in an Oracle forum.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
How can I escape $1 and && in a SED command
Replies
1
Views
345
feherke
feherke
pax94
  • Locked
  • Question
Script automating dynamic queries in a remote host
Replies
0
Views
195
pax94
pax94
grazinggoat2
  • Locked
  • Question
why cant i expand filenames in bash 1
Replies
2
Views
249
grazinggoat2
grazinggoat2
tulsantide
  • Locked
  • Question
setenv not found error in cshrc on a solaris 11 machine
Replies
0
Views
194
tulsantide
tulsantide
boqsc
  • Locked
  • Question
Using IF statement's Regex comparison operator in a C Style For Loop 1
Replies
1
Views
142
feherke
feherke

Part and Inventory Search

Sponsor

Back
Top