Re: How can legally include " ' " (single quote) in my SQL stateme
From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 03/14/05
- Next message: Erland Sommarskog: "Re: Executing a stored procedure on a linked server"
- Previous message: VN: "RE: IRowsetScroll vs ADO RecordCount"
- In reply to: Newbie: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Next in thread: mboizeau_at_free.fr: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Reply: mboizeau_at_free.fr: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Mar 2005 23:03:38 +0000 (UTC)
Newbie (Newbie@discussions.microsoft.com) writes:
> I take your advice and it works beautifully with MS Access. But, I am
> now getting an error of "ORA-00936: missing _expression" when I am
> applying it to Oracle database. For some reason, Oracle does not like
> the use of parameters in SQL statement. My SQL statement is shown in
> the debug mode as below.
>
> insert into table_name
> values(@param1, @param2)
> where column1, column2
>
> I checked Oracle SQL syntax and found nothing missing or wrong with this
> statement. Have you ever experienced this problem? If so, how did you
> resolve it? Thanks again for your advice.
I have never used Oracle, so I'm a bit off-base here. But it may be
that you have to use ? instead of @var with the Oracle OLE DB Provider.
Note that this newsgroup is about using the OLE DB API, so it's not
the best group to get answers for ADO .Net issues, and even less with
Oracle syntax.
-- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
- Next message: Erland Sommarskog: "Re: Executing a stored procedure on a linked server"
- Previous message: VN: "RE: IRowsetScroll vs ADO RecordCount"
- In reply to: Newbie: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Next in thread: mboizeau_at_free.fr: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Reply: mboizeau_at_free.fr: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
