PL/SQL Execute inmediate Update query giving SQLCODE -932

Question

I'm finishing a PL/SQL block but the final update statement is giving me a headache.

The following EXECUTE INMEDIATE thows me an SQLCODE -932 and program breaks.

EXECUTE IMMEDIATE 'UPDATE RS2QTCIN cin SET cin.date_end = '|| dateINSERT ||' WHERE cin.id = '|| REG1.c1id;

The query is just simple, dateINSERT is a variable defined in the declaration block and the value at the end(REG1.c1id), is a result of a cursor also defined.

The update query seems correct and the variables are concatenated with the query string.

Save the query to a string. Then look at the string. The error will be obvious. Or, better yet, fix the execute to use parameters. Don't munge query strings with constant values. — Gordon Linoff
– Gordon Linoff, Commented Mar 24, 2020 at 15:47

user330315 · Accepted Answer · 2020-03-24 15:55:23Z

1

Don't concatenate parameters into the SQL string, use placeholders instead:

EXECUTE IMMEDIATE 'UPDATE RS2QTCIN cin SET cin.date_end = :1 WHERE cin.id = :2'
  USING dateINSERT, REG1.c1id;

But as there are no dynamic identifiers in your SQL, you don't need dynamic SQL to begin with:

UPDATE RS2QTCIN cin 
    SET cin.date_end = dateINSERT 
WHERE cin.id = REG1.c1id;

answered Mar 24, 2020 at 15:55

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Jorge Vega Sánchez Over a year ago

Thanks, works great and also great examples to use in the future.

Collectives™ on Stack Overflow

PL/SQL Execute inmediate Update query giving SQLCODE -932

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related