All Forums Database
DS 10 posts Joined 07/12
16 Dec 2014
Execute immediate - exception handling

Hi All,
 
I am preparing  a dynamic insert statement in stored procedure, i am excuting it by using execute immeidate.
execute immediate (dynamic Insert statement) is failing with sqlcode -5628 ( Column %FSTR not found in %VSTR.). 
I want to continue execution by handling this error. can someone give an example to handle dynamic sql error/exceptions.
I tried by declaring a condition, didn't help...
 
Thanks
DS
 

DS 10 posts Joined 07/12
16 Dec 2014

Hello
did anyone face the same problem with dynamic sql/dml.
If so pls let me know how did you fix it.
 

DS 10 posts Joined 07/12
16 Dec 2014

It is resoved...

chillerm 15 posts Joined 04/11
05 Jan 2015

Can you post how you resolved it?

You must sign in to leave a comment.