Message-ID: <3A3016E4.433B5CAD@ipinc.com>
Date: Thu, 07 Dec 2000 15:01:56 -0800
From: Jie Liang <jliang@ipinc.com>
Organization: ipinc.com
MIME-Version: 1.0
CC: pgsql-sql@postgresql.org
Subject: Re: how to execute a C program via trigger ?
References: <20001204084729.45208.qmail@web10402.mail.yahoo.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

Is any other SQL implicit cursor attribute in PL/plsql ??

when you say (in pl/plsql):

select field into v_1 from atable where whatever;

special variable FOUND can be used to tell return is null or not.

this functions like SQL%FOUND or SQL%NOTFOUND in Oracle,

however, when I do some DML(insert,delete,update), is there any other

special variable can tell me howmany success. Like SQL%ROWCOUNT in Orcale??

And if there is an error such as : cannot insert since duplicate key on an

unique index, is it possible to catch it??

Thanks.

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com