table type

From: Christian \ <Christian.Gulich_at_IN.Stud.TU-Ilmenau.de>
Date: Thu, 10 Jun 2004 14:02:22 +0200
Message-ID: <ca9ifv$8ud$1@piggy.rz.tu-ilmenau.de>

Hallo,
how can I create a table type from an existing table? It must have the same attribute names because I want to use it as return type for a PL/SQL procedure, which does something on the original table. I tried something like this, but it didn't work.

CREATE TYPE TESTER.Videos_TableType AS
TABLE OF TESTER.Videos%ROWTYPE

Do you have any ideas?

Thanks, Christian Received on Thu Jun 10 2004 - 07:02:22 CDT