so apparently oracle does not allow to use create command in stored procedures.
so i have to make an pl/spq table using "TYPE TempContacts IS TABLE OF ...."
the problem is, this command only allows me to make a table variable of only a single column unless i specify a %ROWTYPE for some already existing table. As such table doesnt exist and i want a table variable with a number of specific variables, can anyone tell me how to declare one??
Question
shake
so apparently oracle does not allow to use create command in stored procedures.
so i have to make an pl/spq table using "TYPE TempContacts IS TABLE OF ...."
the problem is, this command only allows me to make a table variable of only a single column unless i specify a %ROWTYPE for some already existing table. As such table doesnt exist and i want a table variable with a number of specific variables, can anyone tell me how to declare one??
Link to comment
Share on other sites
1 answer to this question
Recommended Posts