Re: Passing lists to a procedure

paulwragg2323_at_hotmail.com schrieb:
> 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
> --------
> -----------------------------------------------------------------
> 7/2 PL/SQL: SQL Statement ignored
> 12/22 PL/SQL: ORA-00932: inconsistent datatypes: expected NUMBER
> got
> 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.
>

The solution is not mine, but from William Robertson, what can be seen at the bottom of the page as copyright.
I hope, you read the article carefully and created a SQL type VARCHAR2_TT AS TABLE OF VARCHAR2(4000).
If this is the case, please provide the whole source code, then it will be easier to troubleshoot.

Best regards

Maxim Received on Tue Jan 30 2007 - 09:38:52 CST