PL/SQL (MOSC)

MOSC Banner

Finding a solution to loading several lookup tables into package for reuse several thousand times

edited Nov 24, 2009 4:41AM in PL/SQL (MOSC) 6 commentsAnswered
Currently I have a large package built that makes several thousand calls to ten different tables (look up tables) to validate data before populating it into core tables. Instead of going back and forth to each table for each record is there a way I can load the ids and codes for each table into the package itself or memory? The query is pulling back the ids based on the codes I send. Any help will be greatly appreciated. Thanks in advance! 

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