Re: ODBS SQL

From: DeZack <derantolis_at_yahoo.it>
Date: 18 Oct 2004 03:24:50 -0700
Message-ID: <a2e7d97c.0410180224.43800368@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097892100.999566_at_yasure>...
> DeZack wrote:
>
> > hello how is possible to pass Oracle the command: DECLARE CURSOR ...???
> > as in Postgresql, SQL server ecc ecc?????
> > thanks in advance!!!!
>
> Of what value would it be to pass to Oracle syntax from a different
> product?
>
> Why don't you state the problem you are trying to solve instead?

yes, sure:
i've a program that pass these instructions: "BEGIN;"
"DECLARE C CURSOR FOR SELECT ....;" ecc ... AND
"FETCH 1 IN C" "FETCH -1 IN C"
in order to move the cursor
and therefore to read a record to the time

this program work fine in Postgresql and it has need of some modifications for work in SQLserver, but in oracle don't work!!!!! I don't know what instruction need Oracle 9!!!

I try the instruction with SQL*PLUS!!

thanks for help! Received on Mon Oct 18 2004 - 05:24:50 CDT