Bad Documentation Strikes Again

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Feb 2004 23:39:34 -0800
Message-ID: <1077781139.616483@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 - 01:39:34 CST