Hi everybody,
if someone get's confused by the subject, let me explain:
Oracle 10g on Linux with ODBC installation for DB-Link to Postgresql. That
works very fine!
But, now the problem:
In PL/SQL procedure I open a view on the PGSQL (8.0.3) DB into a cursor
which i want to loop through until E
"Frank Millman" <[EMAIL PROTECTED]> writes:
> [ this doesn't work: ]
> begin ;
> declare fm scroll cursor for select a.CompanyId, b.CompanyName
> from SysUsersCompanies a, SysCompanies b
> where UserId =3D 'Greer' and a.CompanyId =3D b.CompanyId
> order by a.CompanyId ;
> move 1 in fm ;
> fet
Hi allI posted this to the newsgroup on June 11th, but I got no replies.Is the mailing list is a better forum for asking questions of this nature?
Below is a script that creates and populates three tables, and then
creates a scroll cursor to retrieve the data. Mostly it works fine,
but in this
