• 0

ORAcle question


Question

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.