Home » Developer & Programmer » Precompilers, OCI & OCCI » ROWID Null Possible
ROWID Null Possible [message #180739] Wed, 05 July 2006 01:45
mymot
Messages: 225
Registered: July 2005
Senior Member
Hi,

I am going through Pro C code, and in FETCH statement for particular cursor, i am seeing INIDICATOR for rowid defined in the cursor, then latter code is checking whether that INDICATOR for ROWID is null or not by comparing with -1

long rind;

EXEC SQL mycur cursor FOR
select a
       b
       t1.rowid
      from aa,t1
      where <conditions>

....
FETCH mycur into :la
                 :lb
                 :lc:rind;

if(rind != -1)
do something



How the rowid can be null for any table?
If the table has no data then , NO_DATA_FOUND will take care and if field is null then using INDICATOR or NVL one could identify field value?

Any expert opnion on this.

Cheers
Previous Topic: ORA-24333: zero iteration count Proc /Sun Unix
Next Topic: 2 dimensional host varchar array
Goto Forum:
  


Current Time: Thu Mar 28 18:03:04 CDT 2024