Re^4: Bind param error

Kenneth, I added or die "Prepare failed: $DBI::errstr"; to the end of the statement and I get this error now when I try to run it: Prepare failed: ORA-00911: invalid character (DBD ERROR: OCIStmtExecute/Describe) at /home/mundyda/extract.pl line 143. I do not see an invalid character though. Your thoughts? Doug

Comment on Re^4: Bind param error Download Code

Replies are listed 'Best First'.
Re^5: Bind param error by Corion (Patriarch) on Jul 01, 2010 at 20:38 UTC
See Re: Bind param error. Alternatively, assign your SQL statement to a string, and print out that string. Then manually replace the placeholders with dummy values and run it in your SQL command line client.	[reply]
Re^5: Bind param error by kennethk (Abbot) on Jul 02, 2010 at 13:17 UTC
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.	[reply]
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	[reply]