Bad rowtype on PL/SQL Oracle -- does anyone know? - Mailing list pgsql-sql

From Josh Berkus
Subject Bad rowtype on PL/SQL Oracle -- does anyone know?
Date
Msg-id 200305231115.47324.josh@agliodbs.com
Whole thread Raw
List pgsql-sql
Folks,

We need some help from an active Oracle PL/SQL programmer.

What would Oracle PL/SQL do in this case:

DECLARE some_rec some_table%ROWTYPE

SELECT a, b  --but not c, d
FROM some_table INTO some_rec
WHERE a = x;

We're trying to determine what PL/pgSQL should do if given a select statement
which does not match the declared %ROWTYPE, and were wondering what PL/SQL
does.  My PL/SQL manual does not make it clear, and I don't have  a running
8i to test on.

--
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Can arrays reference primary keys in CREATE TABLE?
Next
From: Bruno Wolff III
Date:
Subject: Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST