How can fill a variable of my own created data type within Oracle PL/SQL?
Posted
by Frankie Simon
on Stack Overflow
See other posts from Stack Overflow
or by Frankie Simon
Published on 2010-05-25T08:41:02Z
Indexed on
2010/05/25
9:51 UTC
Read the original article
Hit count: 213
In Oracle I've created a data type:
TABLE of VARCHAR2(200)
I want to have a variable of this type within a Stored Procedure (defined locally, not as an actual table in the DB) and fill it with data.
Some online samples show how I'd use my type if it was filled and passed as a parameter to the stored procedure:
SELECT column_value currVal FROM table(pMyPassedParameter)
However what I want is to fill it during the PL/SQL code itself, with INSERT statements.
Anyone knows the syntax of this?
© Stack Overflow or respective owner
