Toad World® Forums

Virtual column help needed.


#1

UPDATE LRT_EXTRACT_INV_STAGE SET

AND INVESTOR_ID = P_INV_ID;

I’m trying to use a virtual column name, “P_BULK_FLD_NAME” in the SQL statement below. Can someone please explain what I’m missing. I’m getting an error saying, “Virtual column not allowed here.”

So, “P_BULK_FLD_NAME” is a variable that’s storing the name of the field in the table.

Newbe to Toad.

Thanks in advance!
Mike

P_BULK_FLD_NAME = P_UPDATE_TO WHERE REQ_ID = P_REQ_ID