SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unexpected end of SQL command

424865Jul 7 2004 — edited Jul 7 2004

Hi,
I am getting this error:

Oracle Automation error '800a01b8'
SQL execution error, ORA-00921: unexpected end of SQL command

It's pointing to the select statement:

<%
Set OraDynaset = OraDatabase.CreateDynaset(_
"select * from ASCP_USERS where USER_NAME=" &fID, cint(0))
%>

I just starting working with Oracle using ASP..and can't figure it out.

Any ideas how to solve the problem.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2004

Added on Jul 7 2004

2 comments

17,616 views