Toad World® Forums

Problem with SingleValueQuery as an Outcome

I am trying to do what I think is something very easy but I can't seem to get it to work.

In my test outcome, I am trying to do a count (*) on a table to see if a single row exists. My outcome looks like this:

I have an input to my procedure called: P_ID and I am trying to reference it using:

argval_number ('i_P_ID')

When I run my test, I get the following error:

img3.png

What am I doing wrong in order to reference an input parameter value in the outcome section?

Cheers

Duncs

It will be great to see your tested program spec and testing code, which is a package called Q##.

Hi,

I noticed that you are quoting the variable name: ‘i_P_ID’. Perhaps this is your problem.

I was able to reference the input variable without a problem:

Could you confirm that the query is able to run with the literal value, instead of a variable reference?

Best regards,

Ferdinand

Hi Fero

Thanks for the reply.

You are right, removing the call to argval_number() fixed the problem.

I got that from the documentation but wonder if that was from an earlier version of the software.

Anyway, referencing the parameter by name fixes the problem.

Cheers

Duncan