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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Indicator variables

RE: Indicator variables

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 09 Dec 2002 05:58:42 -0800
Message-ID: <F001.00515337.20021209055842@fatcity.com> 






Tom is correct



indicator variables


0 - NOT NULL and data retrieved successfully


-1 - data is NULL



>0 - NOT NULL but possible truncation of data.



In 3gl programs such as C ALWAYS use indicator variables.



Rick




                                                                                                                  
                    "Mercadante,                                                                                  
                    Thomas F"              To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>    
                    <NDATFM_at_labor.st       cc:                                                                    
                    ate.ny.us>             Subject:     RE: Indicator variables                                   
                    Sent by:                                                                                      
                    root_at_fatcity.com                                                                              
                                                                                                                  
                                                                                                                  
                    12/09/2002 08:03                                                                              
                    AM                                                                                            
                    Please respond                                                                                
                    to ORACLE-L                                                                                   
                                                                                                                  
                                                                                                                  








Raj,



from what I remember, a NOT NULL constraint has no impact on an indicator
variable in 3GL programs.



The indicator variable indicates whether the value fetched is null or has a
value.



hope this helps.



Tom Mercadante


Oracle Certified Professional




-----Original Message-----



Sent: Friday, December 06, 2002 4:29 PM


To: Multiple recipients of list ORACLE-L




Hi All,


  What value does an indicator variable in a pro*c program assume when the
fetch column value is NOT NULL. Is is 0 or something other that -1.



  I would appreciate your help.



Thanks,


Rajesh



-----Original Message-----



Sent: Friday, December 06, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L




Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was
that you?



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com




-----Original Message-----



Sent: Friday, December 06, 2002 11:29 AM
To: Multiple recipients of list ORACLE-L




I was afraid that'd be the only way.  Thanks.



Adam



-----Original Message-----



Sent: Friday, December 06, 2002 12:05 PM
To: Multiple recipients of list ORACLE-L




Hi




Set global_names = false in init.ora file and try again



-----Original Message-----



Sent: vrijdag 6 december 2002 17:41


To: Multiple recipients of list ORACLE-L




Don't ask how we got into this situation, but I have two instances with the
same global_name and need to be able to create a link between them.  Is
this


doable?



Adam


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Donahue, Adam


  INET: adam.donahue_at_hcmny.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Jack van Zanen


  INET: JACK_at_QUANTSYSTEMS.NL



Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Donahue, Adam


  INET: adam.donahue_at_hcmny.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: DENNIS WILLIAMS


  INET: DWILLIAMS_at_LIFETOUCH.COM



Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Pillai, Rajesh


  INET: Rajesh.Pillai_at_nordstrom.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--



Please see the official ORACLE-L FAQ: http://www.orafaq.com


--



Author: Mercadante, Thomas F


  INET: NDATFM_at_labor.state.ny.us


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).







-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: 


  INET: Rick_Cale_at_teamhealth.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 09 2002 - 07:58:42 CST












Original text of this message













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