Any ideas?
Have a personal query builder report a user wants to share with another. Tried simple ‘Send to collague’ but that didn't seem to work
Any ideas?
Have a personal query builder report a user wants to share with another. Tried simple ‘Send to collague’ but that didn't seem to work
Here’s some PL/SQL that will copy all the query builder reports from one user to another:
DECLARE
source_user_ VARCHAR2(30) := 'DURETTKETEST1';
destination_user_ VARCHAR2(30) := 'DURETTKETEST2';
info_ VARCHAR2(32767);
objid_ user_quick_report.objid%TYPE;
objversion_ user_quick_report.objversion%TYPE;
attr_ VARCHAR2(32767);
BEGIN
FOR rec_ IN (
SELECT *
FROM user_quick_report_tab
WHERE owner = source_user_
) LOOP
client_sys.clear_attr(attr_);
user_quick_report_api.new__(info_, objid_, objversion_, attr_, 'PREPARE');
client_sys.set_item_value('TITLE', rec_.title, attr_);
client_sys.set_item_value('ROW_TYPE', rec_.row_type, attr_);
client_sys.set_item_value('OWNER', destination_user_, attr_);
user_quick_report_api.new__(info_, objid_, objversion_, attr_, 'DO');
user_quick_report_api.write_sql_expression__(objversion_, objid_, rec_.sql_expression);
user_quick_report_api.write_query__(objversion_, objid_, rec_.query);
END LOOP;
END;
/
COMMIT;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.