Dynamic SQL & returning information?

From: <ranev_at_my-deja.com>
Date: Sun, 20 Jun 1999 21:21:01 GMT
Message-ID: <7kjlvn$p6e$1@nnrp1.deja.com>

Hi there,

I've been trying to execute a dynamic SQL block having several updates in it. It seems to work somehow, but I've not been able to get any data returned to the routine executing it. How is it supposed to manage?

The block so far looks like:

declare

local definitions here, like rc integer := 0 ; begin loop
- something here update ... rc := rc + sql%rowcount; end loop;
How to return rc here ? end;

This block is then parsed and executed by routines dbms_sql.parse and dbms_sql.execute respectively from a procedure. The procedure needs to know if the value of rc differs from zero.

Thanks,
Rauno Veijola
veijola_at_cc.jyu.fi

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jun 20 1999 - 16:21:01 CDT