Re: Identifier must be declared error

In article <5e66b3ce.0409140757.4db576e_at_posting.google.com>, Oliver McErlane says...
> Rather that using the Microsoft ODBC error for Oracle, I tried to use
> the Oracle ODBC driver, in order to append data to an
> Oracle db.
> Unfortunately, I get the error below (bottom of page)=3F.
> Does anyone know what changes that I may have to make to my Oracle
> stored procedure in order to make this work.
> I think that this may be a datatypes problem. Am I right?
>
> <%
> Provider=OraOLEDB.Oracle.1;Password=fir33xit;Persist Security
> Info=True;User ID=live;Data Source=laser"
>
> {call aoppack.getloodetails(?,{resultset 9, APPROVAL_DATE,
> ACCEPT_DATE, PRIOR_CONDS_MET_DATE })}
> OraOLEDB error '80040e14'
> ORA-06550: line 1, column 33: PLS-00201: identifier 'APPROVAL_DATE'
> must be declared ORA-06550: line 1, column 7: PL/SQL: Statement
> ignored
> /aop/grants/raiseaop.asp, line 66
> %>
>

I think you need to post here the pl/sql that is being executed.

-- 

jeremy