From: Jonas <jserrachinha@esoterica.pt>
Subject: Can Oracle do this!?
Date: 2000/08/08
Message-ID: <39902C6B.47D72D50@esoterica.pt>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en,pt
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@mail.telepac.pt
X-Trace: venus.telepac.pt 965753696 22299 194.65.166.48 (8 Aug 2000 16:54:56 GMT)
Mime-Version: 1.0
NNTP-Posting-Date: 8 Aug 2000 16:54:56 GMT
Newsgroups: comp.databases.oracle.server


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@mail.telepac.pt
jserrachinha@esoterica.pt