in reply to Re^4: Bind param error
in thread Bind param error

I think I do see your problem. You have # delimited comments in your SQL, which is legal in some environment (e.g. MySQL) but not in Oracle (based on some articles I just found via the Google.). Try again with your '#' characters swapped to '--', the Oracle way of doing line-end comments.

Replies are listed 'Best First'.
Re^6: Bind param error
by doug145 (Initiate) on Jul 02, 2010 at 20:42 UTC
    Kenneth, at the moment I do not have access to my code (my hard drive failed today), but I will try it. Doug