Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: DBMS_UTILITY
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