Skip to main content
Solved

Custom Event, ORA-01722 Invalid Number

  • December 8, 2022
  • 1 reply
  • 433 views

Forum|alt.badge.img+5

Hi,

 

I’m working with a customer on NCR’s and they want to prevent NCR’s from moving into Released status unless the NCR is connected to an object.

 

I can up with this event action:

And it works when an NCR isn’t connected to a Project. For example, the test NCR 120822-3 throws the error that I'm looking for when I try to release it:

 

However, after connecting the NCR to a project:

I get this error message:

 

And I’m not really sure why. When I run my select statement in Oracle I can see that it’s evaluating to 1:

So, right now I’m at a bit of a loss and I’m hoping someone can help me figure out how to get this over the finish line.

Best answer by eqbstal

@TODDUNCLIFFE,

Should there not be single quotes around &NEW:NCR_NO? in the event. At least that I what normally do.

Steve

View original
Did this topic help you find an answer to your question?

eqbstal
Superhero (Partner)
Forum|alt.badge.img+21
  • Superhero (Partner)
  • December 9, 2022

@TODDUNCLIFFE,

Should there not be single quotes around &NEW:NCR_NO? in the event. At least that I what normally do.

Steve


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings