I hope I post at the right place. If not , my apology.
I created the function:
create function get_machine_detail ( smallint) return text as' .....
which works fine when test in the pgAdminII sql window.
I am trying to call this stored proc from delphi 6 ADOstoredproc'
parameter setup are as follow:
'DataType' = ftsmallint
'direction' = pdinput
value :type smallint
'datatype' = ftstring
'direction' = pdReturnValue
'value:type : unassigned
I get an error stating that 'parameter object is improperly defined'
Any suggestion.
Thanks