Database DataWarehousing (MOSC)

MOSC Banner

materialized view using java stored procedure

edited Jan 14, 2010 12:57AM in Database DataWarehousing (MOSC) 3 commentsAnswered
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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center