Can Oracle do this!?

From: Jonas <jserrachinha_at_esoterica.pt>
Date: 2000/08/08
Message-ID: <39902C6B.47D72D50@esoterica.pt>#1/1

Hi all.
I'm trying to move my SQL code from IB to Oracle, but there are problems.
In IB using a stored procedure, I can at any time return the values of the returns variables.
For example:
  FOR SELECT a, b FROM myTable
  WHERE c = 'XXXX'
  INTO :RA, :RB
  DO BEGIN
    SUSPEND; <-- Fetch all returns variables (Now with the quey values)     RA = 'AAA';
    RB = 'BBB';
    SUSPEND; <-- Fetch all returns variables (Now with my values)   ....
Can I do this in Oracle?

Tanks in advance!

jserrachinha_at_mail.telepac.pt
jserrachinha_at_esoterica.pt Received on Tue Aug 08 2000 - 00:00:00 CDT