Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing lists to a procedure

Re: Passing lists to a procedure

From: <paulwragg2323_at_hotmail.com>
Date: 30 Jan 2007 07:16:14 -0800
Message-ID: <1170170174.150672.240720@a75g2000cwd.googlegroups.com>

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. Received on Tue Jan 30 2007 - 09:16:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US