Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_UTILITY

Re: DBMS_UTILITY

From: Mukesh Agrawal <Mukesh.Agrawal_at_alltel.com>
Date: Fri, 30 Jun 2000 0:54 -0500
Message-Id: <10543.110869@fatcity.com>

       Hello Dear,

       Try this code.

       SQL> declare
         2  file_id number;
         3  begin
         4  file_id :=
       dbms_utility.data_block_address_file(604140218);
         5  dbms_output.put_line(to_char(file_id));
         6  end;
         7  /

       You will get the proper result.

       Only one thing you must kept in mind is that function always
       return a values.
       so you should have handler to store that return values in
       proper variable.

       Thanks
       Mukesh
       (DBA Alltel India)
Received on Fri Jun 30 2000 - 00:54:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US