ORA-24374: define not done before fetch or execute and fetch error

I'm facing this error, when I try to create new job(in Replace Mode) in workbench.

 

ORA-24374: define not done before fetch or execute and fetch error

Comments

  • Hi, Is anyone able to help out with this request? Thanks,

  • It seems like nobody knows the solution to my problem.

  • Did you get past through this error ????

  • AS
    AS 🔵

    As always, Oracle errors are super helpful...

     

    Do you have a function, procedure, cursor, variable, or similar object in your query? This looks to me like your query is looking for something that isn't defined before that object is called.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Yeah I did. I just removed all the commented rows from the query.

This discussion has been closed.