Re: How can legally include " ' " (single quote) in my SQL stateme
mboizeau_at_free.fr
Date: 03/17/05
- Next message: VN: "RE: Strange record sets from a stored procedure"
- Previous message: shel: "How to download ole objects(MS Access) from ASP?"
- In reply to: Erland Sommarskog: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Messages sorted by: [ date ] [ thread ]
Date: 17 Mar 2005 07:01:10 -0800
Yes "?" is the solutions.
I ve put a sample code here :
http://oraclevsmicrosoft.blogspot.com/2005/03/quotes-parameters.html
hope this helps
Marc Boizeau
http://oraclevsmicrosoft.blogspot.com
Erland Sommarskog wrote:
> 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: VN: "RE: Strange record sets from a stored procedure"
- Previous message: shel: "How to download ole objects(MS Access) from ASP?"
- In reply to: Erland Sommarskog: "Re: How can legally include " ' " (single quote) in my SQL stateme"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
