Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

VS 2008 -- ORACLE -- TableAdapter Wizard

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
finance_teacher
Asked:
finance_teacher
1 Solution
 
mrjoltcolaCommented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now