Solved

VS 2008 -- ORACLE -- TableAdapter Wizard

Posted on 2009-07-08
1
437 Views
Last Modified: 2013-12-17
The below "WHERE FMCODE = @FMCODE" works fine when using the VS 2008 TableAdapter with MSSQL, but fails with a "ORA-00936 missing expression" ERROR when doing via Oracle 10g.

Attached are my notes and Oracle schema.
  ** Expert Exchange does not allow me to post the VS.net APP

How can I fix ?
---------------------------------------------------------------------
SELECT     FMALERTS, FMCODE, FMCOMPONENTTOTAL, FMDENSITY, FMDENSITYCNVT, FMENTITYID, FMENTITYOBJECTID, FMHYPERLINK, FMISTEMPLATE,
                      FMLOSS, FMNONPUCOST, FMNONPUULCOST, FMNOTEBOOKNUMBER, FMNOTEBOOKPAGES, FMPRODUCEDRESOURCE, FMPUCOST,
                      FMPUCOSTCNVT, FMPUULCOST, FMPUULCOSTCNVT, FMREFSECTYPEID, FMREFSTATUSID, FMREFUSERTYPEID, FMTEMPLATEID,
                      FMTOTALBATCHSIZE, FMTOTALBATCHSIZECNVT, FMUNITIDCOST, FMUNITIDFORMULATOR, FMUNITIDSTDBATCH, FMUNITIDSTDDENSITY,
                      FMVERSION
FROM         FMFORMULA
WHERE FMCODE = @FMCODE
ORDER BY FMCODE, FMENTITYID, FMVERSION
note.zip
0
Comment
Question by:finance_teacher
1 Comment
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 125 total points
ID: 24807605
You cannot use @ syntax in Oracle. That is SQL Server syntax.

For bind variable use the :syntax or the ? syntax.

Otherwise, variables are not prefixed with any @, they are simply declared like:

DECLARE
   i  integer;
   s varchar;
BEGIN
  i := 1;
END;
/
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question