Double-click on the history and look at the actual error message.
I presume this is a portion of the stored procedure?
You can't use a SELECT within a SET. Use SELECT INTO syntax instead.
Fred - What do you mean by use SELECT INTO syntax instead.
Im facing similar issue when executing Minus/EXCEPT ALL
From Table1 where <condition>
In the earlier post, instead of the SET with a subquery:
SELECT MAX(V_MONTH) INTO :MAX_DATE FROM DB_TEMP.HISTORIAL_DATA;
I'm not clear on how your question is a "similar issue". Can you provide more information as to the actual error you are seeing?