Bad rowtype on PL/SQL Oracle -- does anyone know?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Bad rowtype on PL/SQL Oracle -- does anyone know?
Дата
Msg-id 200305231115.47324.josh@agliodbs.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Can arrays reference primary keys in CREATE TABLE?
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST