How to validate entries to oracle raw column

Asked Aug 05 '20 at 07:01

Active Aug 05 '20 at 07:58

Viewed 153 times

I have a requirement where before entry to a raw column, first the data needs to be validated in Java. I guess what I need is a hex validation?.

I saw some approaches in Verify if String is hexadecimal

But wanted to know if there are any libraries or (Since the above question is pretty old) options available in newer versions of Java that does this, specifically a solution which does not fail due to the size of the String, for eg, Long.parseLong can fail if it is found to be beyond the Long range

edited Aug 05 '20 at 07:58

asked Aug 05 '20 at 07:01

rajesh

3,247
5
31
56

you can use `utl_raw.cast_to_varchar2` to validate the raw as string – Roberto Hernandez Aug 05 '20 at 07:06
Do you want to verify in java code or in Oracle database? Wasn't RAW data-type replaced with LOB (Large OBject) as in BLOB or CLOB? – Abra Aug 05 '20 at 07:17
@Abra in Java code. I have situation where I need to deal with RAW – rajesh Aug 05 '20 at 07:19
If you want only Java, the `oracle` tag should be removed from the question – Roberto Hernandez Aug 05 '20 at 07:38
1

It is to check entry into an oracle raw column. – rajesh Aug 05 '20 at 07:58
Oracle triggers can be written in Java and executed in the built-in JVM in Oracle, see https://stackoverflow.com/a/54727938/4178262 for example. – Mark Stewart Aug 05 '20 at 13:44

How to validate entries to oracle raw column

0 Answers0