Re: Bad Documentation Strikes Again

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 26 Feb 2004 10:33:23 -0000
Message-ID: <403dcb73$0$7059$ed9e5944@reading.news.pipex.net>

blame it on the developer. The docs seem to have been generated from dbmsutil.sql which contains the same clear as mud wording.

I do like the version history though

Rem tpystyne 10/01/92 - fix Bob's mistakes

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1077781139.616483_at_yasure...


> Ok here's the reference:

>

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_util2.htm#998631


>

> Note that it says:

>

> "context Must be an integer between 0 and 8."

>

> Well by between they sure don't mean you can use 0 or 8 but there is

> no hint anywhere as to what 1, 2, 3, 4, 5, 6, or 7 mean.

>

> I did some experimenting and 1 seems to equate to functions,

> procedures and packages. 2 seems to equate to tables and synonyms.

>

> Otherwise ... this most certainly constitutes some of the most

> challenged documentation I've seen lately.

>

> Anyone wanting to test this can use the following:

>

> set serveroutput on

>

> DECLARE

>

> my_object VARCHAR2(100) := <schema_name.object_name>;

> s  VARCHAR2(30);

> p1 VARCHAR2(30);

> p2 VARCHAR2(30);

> d  VARCHAR2(30);

> o  NUMBER(10);

> ob NUMBER(10);

>

> BEGIN

>    dbms_utility.name_resolve(my_object, 2, s, p1, p2, d, o, ob);

>

>    dbms_output.put_line('Owner:  ' || s);

>    dbms_output.put_line('Table:  ' || p1);

>    dbms_output.put_line('Column: ' || p2);

>    dbms_output.put_line('Link:   ' || d);

> END;

> /

>

> Thanks.

>

> -- 

> Daniel Morgan

> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp

> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp

> damorgan_at_x.washington.edu

> (replace 'x' with a 'u' to reply)

>

Received on Thu Feb 26 2004 - 04:33:23 CST