materialized view using java stored procedure
We have a process that currently calls a java stored procedure to convert and validate a column. Rather than call this procedure many times over for the same row we want to convert/validate once and store the result in a materialized view(mv).
We normally execute the java stored procedure as show below;
exec osrecode.Osre_Java_Utils.Pseudoesnutil(Meid_To_Hex(esn)) However to create a mv view I must somehow get the above exec into a select statement and so far I have had no luck. Any ideas?
TIA
0