I am an Oracle Developer and know nothing about SQL Server but someone is trying to call one of my procedures from SQL Server and generally it works ok apart from one problem. There is one out parameter - a refcursor, and most fields in the refcursor return fine (tested one by one to see where failing), but where there was a field created from a function in the select statement (eg. display_name in code section below), then it attempts to return it as a varchar2(4000) (which I think is the default in PL/SQL) even though the record type in the spec specifies it as varchar2(45). Now we can get it to work by SQL Server setting their parameter to 4000 also, but it seems a risky implementation, possible performance problems maybe, not sure will test. But wondering if anyone has come across this and knows how to address it properly?
eg. ttl_abbr title,