Package constant as parameter in Test window

[Gustavo]

Hi!

I have a Test window with a float type parameter in the grid. I assigned it a value in the form:
..
When I try to run the test window I get the following error:
Variant conversion error for variable :

Regards,
Gustavo

 

[Gustavo]

BTW, Sysdate is not accepted either.

Also, if parameter type is varchar and constant is char/varchar, it works fine.

PLSD 7.1.5.1397

Regards,
Gustavo

 

[Gustavo]

Please, disregard former info on varchar parameter. Is just doesn't raise an error, and allows me run, but the parameter is not correctly passed and my handler returns an error.

 

[Marco Kalter]

You can only use literal numbers in the variable list. Other expressions are currently not supported.

 

[scottwmackey]

Just define the variable in the DECLARE clause. Why do you need it in the grid?

 

[Gustavo]

@scott - I don't "need" it in the grid, but that's the way PLSD gives me the test window when I right-click and select "Test". I expected it to work as usual.

@Marco - Could this be enhanced?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Gustavo]

Thx! Given this list's length, I hope this one doesn't go to the end.

Regards,
Gustavo