PL/SQL (MOSC)

MOSC Banner

Using Exceute immediate to update Dynamic data -- Error invalid SQL statement

edited Oct 29, 2009 4:00AM in PL/SQL (MOSC) 4 commentsAnswered
Database oracle9.2.0.7

I am trying to create a SP to Execute Update statements dynamically.I am doing the following things.

1)create a curor with the statement

CURSOR index1 index1

IS

SELECT '''Update MUREXODS.RT_INDEX U SET (U.M_FIXING, U.M_INS_DATE) IN (SELECT B.M_FIXING,B.M_INS_DATE from ' || trim(M_FIXING_TABLE) || ' B INNER JOIN ' || trim(M_TABLE_NAME)|| ' H ON H.M_KEYID = B.M_KEYID WHERE trim(H.M_KEY0) = trim(U.M_CURRENCY) AND trim(H.M_KEY1) = trim(U.M_RAT_FREQ) and B.M_DATE = U.M_DATE AND U.M_HISFILE = '''''

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