PL/SQL (MOSC)

MOSC Banner

cannot find record data in bmql query result

in PL/SQL (MOSC) 1 commentQuestion

Code:

msgRS=bmql("SELECT MessageID, Message FROM MessageMaster2 WHERE LanguageCode = $languageCode OR LanguageCode='*' ORDER BY LanguageCode ASC,ModifiedDate ASC" );

Current language is ko_KR and checked in data table MessageMaster2, for messageID ‘VM-51_HPI’, we have two records matched.


But can only find one record which languageCode='*'.

do we have the query number limitation? can you extend this?

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