This I believe may end up as a "No way from here", but here goes anyway. I've a developer who has created a function that returns a table type. We had to create the type and then a table of in this manner:
create type gatekeeper_info as object (model_number varchar2(20), product_id integer, grade varchar2(1), test_description varchar2(70), gatekeeper_value varchar2(2), status varchar2(20)); / create or replace type gatekeeper_info_tbl as table of gatekeeper_info; / The function returns gatekeeper_info_tbl & it works damned well if your logged onto that database. The problem is that they now want to access this function & have it return data from a remote database. Consequently we're getting the ORA-30626 error message. Is there any way known to get around this? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
