From charliem@mwh.com Fri, 02 Feb 2001 09:23:38 -0800 From: "Charlie Mengler" Date: Fri, 02 Feb 2001 09:23:38 -0800 Subject: Oracle Browser & SQL Functions Message-ID: MIME-Version: 1.0 Content-Type: text/plain Happy Friday Fellow Listers! This is some what of a repeat to my last post WRT creating a new "global" function. I have successfully created a new function that is available from SQL*Plus. However we don't allow most folks here to use SQL*Plus, but provide them with Oracle Browser to run their ad-hoc queries against the database. Some how/way Browser "knows" about the Oracle supplied functions (such as RTRIM, MAX, etc.). AFAIK the SQL Functions are not "real database objects". I have been unable to find them within DBA_OBJECTS. They seem to be "intrinsic" to the database. My desire/question is how can I add my newly written function to the list of functions that Browser will allow folks to use within this utility. TIA & HAND! -- Charlie Mengler Maintenance Warehouse charliem@mwh.com 10641 Scripps Summit Ct 858-831-2229 San Diego, CA 92131 HOME DEPOT - The Big Boy's Toy store!!!!!!!!!!!!!!!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem@mwh.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).