stored procedures - configure behaivour issue

[[email protected]]

Hi
I have a stored procedure with the following signature

CREATE OR REPLACE FUNCTION cbill.insert_attributes(p_id integer, p_attribute_type character varying, p_attribute_name character varying)
RETURNS integer AS

I have 2 classes (or tables)
all_attributes
attribute_type


I want to map the all_attributes class to the above stored procedure. In terms of mapping,

p_id is mapped to all_attributes.id
p_attribute_name is mapped to all_attributes.attribute_name
p_attribute_type is mapped to attribute_type.description (all_attributes.attribute_type_id is a foreign key to attribute_type.id)


The problem is with the last mapping. I need to map that parameter to the description column, however only attribute_type.id is displayed in the Property drop down list. How can i get the description property to appear?

[Shalex]

As we understood, you are mapping your all_attributes class to the insert_attributes procedure. In this case attribute_type.description should not be available for mapping. The attribute_type.id property is available for mapping because you have set an association between attribute_type.id and all_attributes.attribute_type_id.