Skip to Content
0
Jun 23, 2015 at 06:36 AM

Error with prompt definition in Derived table

136 Views

Dear Experts,

We are defining prompts in Derived table for the object, getting error message invalid prompt definition when validating SQL.

Below is the code

Select table.column1 from table

where table.colum2 ='X'

And table.column1 in @prompt(......)

If we use same prompt definition individually it is working fine but it throwing error in derived table.

Can any one throw some insight on this.