Dynamic SQL in PRO-C (type 3), problem with NULL

Article View: comp.databases.oracle.server

Article #73

Back to comp.databases.oracle.server Previous Next

#73

From: Riccardo D.S.
Date: Fri, 31 Mar 2000 00:00

16 lines
1411 bytes

I use e dynamic SQL statment (pro c - type 3 ) to estract
the value of single column and put it in the host-variable.
When the return of query is Null the SQL statment  go in error .
Is it possible when this occur continue the process?
Now use the NVL function to return a particulat string
or number when the value is NULL. I prefer ignore the select
when tha value is Null and continue to other select.

Thanks,
Sorry for my english...

I'm italian

Dott. Riccardo Di Stefano
Alenia Marconi System s.p.a.
Rome - Italy

Technical Details

Message-ID: <38E49951.D6D2CB0A@aleniasystems.finmeccanica.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fa4f9,a8bbdcae33011cd9,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f5464,a8bbdcae33011cd9,start
X-Google-Attributes: gidf5464,public
X-Google-Thread: f99a8,a8bbdcae33011cd9,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 103117,a8bbdcae33011cd9,start
X-Google-Attributes: gid103117,public
From: "Riccardo D.S." <rdistefano@aleniasystems.finmeccanica.it>
Subject: Dynamic SQL in PRO-C (type 3), problem with NULL
Date: 2000/03/31
Message-ID: <38E49951.D6D2CB0A@aleniasystems.finmeccanica.it>
X-Deja-AN: 604980774
Content-Transfer-Encoding: 7bit
Organization: Finmeccanica
X-Accept-Language: en,it
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,cern.oracle.cde,comp.databases.oracle.misc