Execute immediate - exception handling

Database
DS
N/A

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

3 REPLIES
DS
N/A

Re: Execute immediate - exception handling

Hello

did anyone face the same problem with dynamic sql/dml.

If so pls let me know how did you fix it.

DS
N/A

Re: Execute immediate - exception handling

It is resoved...

Re: Execute immediate - exception handling

Can you post how you resolved it?