Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ROWID issue between v7 and V8
A copy of this was sent to George Zachary <georgez_at_tig.com.au>
(if that email address didn't require changing)
On Fri, 28 May 1999 00:39:25 +1000, you wrote:
>Hi,
>
>I upgraded an Oracle database from 7.3.2 to 8.0.5. There are some apps
>using ROWID and what I want
>to double check is that in my particular case there is no need to use
>the DBMS_ROWID package.
>The Migration Manual states that application that do not attemp to
>assemble or disassemble ROIDs manually
>do not need to be changed or recompiled. Applications that attemp to
>manufacture or analyze
>the contents of ROWIDs have to use the DBMS_ROWID package.
>
>In my case, I have seen in a ProC program
>
>EXEC SQL DECLARE CUR_1 CURSOR FOR
>SELECT ROWID,
> AREA| | SERV
>FROM ORDERS;
>
>...................
>EXEC SQL FETCH CUR_1
>INTO : rowid ..........
>
>and somewhere later an update function containing
>
>EXEC SQL UPDATE ORDERS
>SET AREA =:x
> SERV =y
>WHERE ROWID = :rowid
>
>Because the value of the ROWID is only used in the WHERE clause I assume
>that the code should work
>without any modification. Am I right ?
yes -- thats all right..
>
>I also found this in a procedure within a form4.5
>
>select ....
> where...
> and rowid <>nvl(:entry.rowid,0);
>
>and in a block
>
thats fine.
>DEFINE BLOCK
>.....
>
>where rowid in (select cont.rowid from cont ....
>
>Any advice much appreciated,
>
> George
also OK.
See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Fri May 28 1999 - 08:30:49 CDT
![]() |
![]() |