Re: DBMS_Rowid

From: <Winnie_Liu_at_infonet.com>
Date: Tue, 17 Oct 2000 09:34:40 -0700
Message-Id: <10652.119502@fatcity.com>

Arun,

Try this. I got this from Metalink.

=> DBMS_ROWID.ROWID_INFO: returns individual components of a specified rowid.

    This procedure can NOT be used in a SQL statement (must use PL/SQL).

     Header:

     procedure dbms_rowid.rowid_info
     (rowid_in in rowid
     ,rowid_type out number
     ,object_number out number
     ,relative_fno out number
     ,block_number out number
     ,row_number out number)

    SQL> set serverout on

    SQL> set echo on

    SQL> @rowid

    SQL> declare

         my_rowid rowid;
         rowid_type number;
         object_number number;
         relative_fno number;
         block_number number;
         row_number number;
         begin
         my_rowid :=dbms_rowid.rowid_create(1,5078,5,3061,0);
         dbms_rowid.rowid_info(my_rowid, rowid_type, object_number,
         relative_fno, block_number, row_number);
         dbms_output.put_line('ROWID:   ' || my_rowid);
         dbms_output.put_line('Object#:      ' || object_number);
         dbms_output.put_line('RelFile#:     ' || relative_fno);
         dbms_output.put_line('Block#:       ' || block_number);
         dbms_output.put_line('Row#:         ' || row_number);
         end;
         /

    ROWID: AAABPWAAFAAAAv1AAA
    Object#: 5078
    RelFile#: 5
    Block#: 3061
    Row#: 0

"ARUN K C" <arun_k_c_at_hotmail.com>@fatcity.com on 10/16/2000 10:45:27 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: DBMS_Rowid

Hello All,
I am trying to get a particular rowid info using the dbms_rowid utility. Since I lack programming skills I am unable to know where exactly to give the parameters.
If I run
execute dbms_rowid.rowid_info
I get errors
Can somebody please help me out as to how exactly this has to be run Thanks
Arun

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ARUN K C
  INET: arun_k_c_at_hotmail.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_at_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

Received on Tue Oct 17 2000 - 11:34:40 CDT