Re: DBMS_SQL.BIND_VARIABLE in query?

Matt Houseman wrote at 17-Feb-00 17:49:32 on the subject DBMS_SQL.BIND_VARIABLE in query?:

[...]

>nEmpNo Number;
>...
>nEmpNo := 1;
>...
>DBMS_SQL.BIND_VARIABLE ( cursor, ':empno', nEmpNo );

>If anyone has some sample code that can be posted, I would greatly
>appreciate it.

Hello Matt,
if I remember correctly you simply have to ommit the ':' in the bind_variable statement. I.e.:

DBMS_SQL.BIND_VARIABLE ( cursor, 'empno', nEmpNo );

I think it's worth a try!

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |