| FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398268] |
Wed, 15 April 2009 17:14  |
s.vishalkumar@gmail.com
Messages: 22
Registered: July 2007
|
Junior Member |
|
|
Hello Everyone!!
I have block in which I choose 'From Clause Query' in the property pallete and pasted this query.
--------------------
select unique product_type PRODUCT_TYPE
from product
where supplier_id = :b00.SUPP_VAL
and product_gl_class_cd = :b00.gl_class
and product_brand = :b00.prod_brand
and product_legal_name = :B00.pln
order by 1
--------------------------
It works fine when I hardcode the values to it, but when I dynamically want to do, it throws me the following errors:
FRM 40505: ORACLE Error: Unable to perform Query
and when I press SHIFT + CTRL+E for errors it displays the following:
ORA-22806: not an object or REF
and the code which it shows is above.
Anyone who is aware of such kind of issues please help me out urgently.
Thanks,
Vishal
|
|
|
|
|
|
|
|
| Re: Help reqd. Re: FRM 40505 : unable to perform Query / ORA-22806 not an object or REF [message #398607 is a reply to message #398598] |
Thu, 16 April 2009 22:22  |
s.vishalkumar@gmail.com
Messages: 22
Registered: July 2007
|
Junior Member |
|
|
Hi Martin!!
The form is something like this:(in a hierarchical manner)
I have a Supplier ID : beside it I have a choose button, which when chosen gives a LOV.I can choose some value
Next I have GL class Code : which is based on the previously chosen supplier ID. It again has a LOV.
Next I have a product_brand : which is again based on the previously chosen 2 values....and so on.
So the product type is based on the 4 values given in the Query.
I have already created an LOV for product type, but the actual requirement was to be able to choose multiple values from the LOV instead of just one value.
For this reason I have taken an approach of creating check boxes on a new window/canvas.
So, in that I have chosen 'FROM CLAUSE QUERY' from property pallete. and pasted the LOV code which worked previously inside Query Source(All of the code in property pallete).
This is the code I have:
select unique product_type
from product
where (:b00.supp_val = 'ALL' or supplier_id = :b00.supp_val)
and (:b00.gl_class = 'ALL' or product_gl_class_cd = :b00.gl_class)
and (:b00.prod_brand = 'ALL' or product_brand = :b00.prod_brand)
and (:B00.Pln = 'ALL' Or Product_Legal_Name = :B00.Pln)
ORDER BY 1
So, when I paste this code and run I am getting the error
FRM 40505.
When I hardcode the values, I get the correct results, but when I want to pass dynamically I am not able to.
Please could you let me know where I am going wrong.
Any knid of help would be greatly appreciated!!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
