on 10-18-2012 6:20 AM
Hi Experts,
I am trying to implement cascading prompts in IDT. Whenever i use @promt in the LOV of second prompt, and try to execute a query, I am getting the following error message. "Some objects are no longer available in the universe. (WIS 00001)". If i hardcode some value instead of @prompt, the query is running perfectly fine.
Can anybody help me how to solve this issue.
Your help would be highly appreciated.
Regards,
Nikhil Joy
Please compare the generated queries when you hardcode values and use @prompt. Share the SQL generated in both scenarios for investigating.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.