| 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
![]() |
![]() |