Solved

VS 2008 -- ORACLE -- TableAdapter Wizard

Posted on 2009-07-08
1
444 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

732 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