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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ROWID issue between v7 and V8

Re: ROWID issue between v7 and V8

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 28 May 1999 13:30:49 GMT
Message-ID: <37599a69.9194581@newshost.us.oracle.com>


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

Original text of this message

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