ORA-02005 error

[mayursh]

Hi,

can anyone help me regarding this query,

The exception thrown is: "ORA-02005 implicit (-1) length not valid for this
bind or define datatype"

if i run the query independently on oracle i wont get any eaception but when run thr the exception

i get this error, kindly help me regarding the same.

reply to my mail id.

this is the details i get regarding the query

ORA-02005: implicit (-1) length not valid for this bind or define datatype
Cause: A negative length for the define variable was passed to a define function.
Action: An explicit, non-negative, length parameter must be passed.

[davey23uk]

show the code and full but small example

[pbhowmik]

Hello,

I am also getting the same problem, when I am executing from the PL/SQL developer its works well, but then ever I am trying to execute the procedure from the c# code its pop up with this error I am not getting where exactly its wrong.

Thanks,
Prasanta