Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing lists to a procedure
Maxin - on 2nd thoughts I am not too sure I understand your solution.
I have changed my procedure so it has the following line at the beginning (prior to declaration of the cursor):
strTableList CONSTANT VARCHAR2_TT := VARCHAR2_TT(strTables);
But now when I createthe procedure I get:
LINE/COL ERROR
I4410ADM.VARCHAR2_TT So I am not quite sure how I can adapt this as it seems the IN clause does not want to take the string table as an argument.
Any help would be appreciated. Received on Tue Jan 30 2007 - 09:16:14 CST
![]() |
![]() |