dbms_rowid包的BUG问题
declare
ridtyp number;
objnum number;
relfno number;
blno number;
rowno number;
rid rowid;
begin
select rowid into rid from test where id=10;
dbms_rowid.rowid_info (rid,ridtyp,objnum,relfno,blno,rowno,'SAMLLFILE');
end;
/ 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
declare
*
ERROR at line 1:
ORA-01410: invalid ROWID
ORA-06512: at "SYS.DBMS_ROWID", line 54
ORA-06512: at line 10
ridtyp number;
objnum number;
relfno number;
blno number;
rowno number;
rid rowid;
begin
select rowid into rid from test where id=10;
dbms_rowid.rowid_info (rid,ridtyp,objnum,relfno,blno,rowno,'SAMLLFILE');
end;
/ 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
declare
*
ERROR at line 1:
ORA-01410: invalid ROWID
ORA-06512: at "SYS.DBMS_ROWID", line 54
ORA-06512: at line 10
