X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 8727E9DC93E
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Mar 2006 18:10:02 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 42611-01
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue,  7 Mar 2006 18:10:02 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.207])
	by postgresql.org (Postfix) with ESMTP id EEB4A9DC804
	for <pgsql-admin@postgresql.org>; Tue,  7 Mar 2006 18:09:58 -0400 (AST)
Received: by nproxy.gmail.com with SMTP id h2so25837nfe
	for <pgsql-admin@postgresql.org>; Tue, 07 Mar 2006 14:10:00 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=U+TnSufp0nz2VDZIgVGV48+3B8mhdzV+R+WsT6XW9CSo4dqHBCK0ql81kGVhTS8ajnZl6sX7dm0hsv2HDn4b5lQbkS0Ygqlo/l9paXlfoLILdko05vV5YC9E+mQ2deTltXiDwc/6/F0I35DWvpfEhsqwJLlQjsgQw1jLK4IiyEg=
Received: by 10.49.6.7 with SMTP id j7mr11201nfi;
	Tue, 07 Mar 2006 14:09:56 -0800 (PST)
Received: by 10.49.35.18 with HTTP; Tue, 7 Mar 2006 14:09:56 -0800 (PST)
Message-ID: <912a25750603071409p1204d1f6je8dc7fb13f68cca5@mail.gmail.com>
Date: Tue, 7 Mar 2006 17:09:56 -0500
From: "German Raul Hoyos Parravicino" <rhoyos@gmail.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Fwd: Question
In-Reply-To: <912a25750603071236y6e61aa8ajb314650012d63928@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_181_22398613.1141769396723"
References: <912a25750603071236y6e61aa8ajb314650012d63928@mail.gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.158 required=5 tests=[AWL=0.157,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.158
X-Spam-Level: 
X-Archive-Number: 200603/78
X-Sequence-Number: 20835

------=_Part_181_22398613.1141769396723
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

---------- Forwarded message ----------
From: German Raul Hoyos Parravicino <rhoyos@gmail.com>
Date: Mar 7, 2006 3:36 PM
Subject: Question
To: pgsql-general-owner@postgresql.org

 Dear Administrator:

I have a problem developing a ECPG program. I am making a programa using
FETCH, when the second row is sent the following message appear:

=3D=3D>sqlcode [-213] msg[NULL value without indicator in line 1192.]

My select is:

        EXEC SQL FETCH cursor_onlyweb
        INTO
                :t_token,
                :t_institucion,
                :t_usuario,
                :t_horasistema,
                :t_pan,
                :t_prcode,
                :t_amount,
                :t_acqinst,
                :t_source,
                :t_datosreq;

Is it possible to use something similar to "isnull" in Oracle?

Thanks

Raul

------=_Part_181_22398613.1141769396723
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<br><br>---------- Forwarded message ----------<br><span class=3D"gmail_quo=
te">From: <b class=3D"gmail_sendername">German Raul Hoyos Parravicino</b> &=
lt;<a href=3D"mailto:rhoyos@gmail.com">rhoyos@gmail.com</a>&gt;<br>Date: Ma=
r 7, 2006 3:36 PM
<br>Subject: Question<br>To: <a href=3D"mailto:pgsql-general-owner@postgres=
ql.org">pgsql-general-owner@postgresql.org</a><br><br></span>
<div style=3D"DIRECTION: ltr">
<div>Dear Administrator:</div>
<div>&nbsp;</div>
<div>I have a problem developing a ECPG program. I am making a programa usi=
ng FETCH, when the second row&nbsp;is sent the following message appear:</d=
iv>
<div>&nbsp;</div>
<div>=3D=3D&gt;sqlcode [-213] msg[NULL value without indicator in line 1192=
.]</div>
<div>&nbsp;</div>
<div>My select is:</div>
<div>&nbsp;</div>
<div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXEC SQL FETCH cursor_onlyw=
eb<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTO<br>&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :t=
_token,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; :t_institucion,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :t_usuario,<b=
r>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp; :t_horasistema,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :t_pan,<br>&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; :t_prcode,=20
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; :t_amount,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :t_acqinst,<br>&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; :t_source,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :t_datosreq;<br>&nbsp;</div>
<div>Is it possible to use something similar to &quot;isnull&quot; in Oracl=
e?</div>
<div>&nbsp;</div>
<div>Thanks</div></div>
<div style=3D"DIRECTION: ltr"><span class=3D"sg">
<div>&nbsp;</div>
<div>Raul</div></span></div>

------=_Part_181_22398613.1141769396723--