出现不支持的 SQL92 标记: 12:

[darkhorse001]

各位社友：
你们好，编译jsp代码出现如上错误，这是执行这个bean的代码，我不知道哪里错了，请各位帮帮忙，谢谢！
=========================================================================

public ArrayList getAera_cash(String bdate,String pdate,String area,String custid,
String itemid,String salep) //区域业绩查询
{
ArrayList list=new ArrayList();
String str=null;
try
{ OracleDBConnection dbc=new OracleDBConnection();
//DBConnectionPool conn=new DBConnectionPool();
Connection conn=dbc.getConnection();//创建一个连接


CallableStatement stmt=conn.prepareCall("{add_cust_oe(to_date(bdate,'YYYY-MM-DD'),to_date(pdate,'YYYY-MM-DD'))}");
//CallableStatement stmt=dbc.prepareCall("{add_cust_oe}");
stmt.execute();

str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m";
str= str + " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b";
str= str + " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER";
str= str + " and b.ORG_ID = 42";
str=str +"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"+area +"' Or '"+area+"' is null)";
str= str + " AND (A.ACCOUNT_NUMBER = '"+custid +"' OR '"+ custid +"' IS NULL)";
str= str + " AND (A.CROSS_REFERENCE = '"+itemid +"' OR '"+itemid +"' IS NULL)";
str= str + " AND (A.NAME = '"+salep +"' OR '"+salep +"' IS NULL)";
str= str + " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME";
str= str + " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER";
ResultSet rs =dbc.executeQuery(str);
while(rs.next())
{
Achievement form=new Achievement();
form.setArea(rs.getString(1));
form.setPro_id(rs.getString(2));
form.setAch_name(rs.getString(3));
form.setCash(rs.getFloat(4));
form.setCash1(rs.getFloat(5));
list.add(form);
}
conn.close();
rs.close();
dbc.close();
stmt.close();
}
catch(Exception ex)
{
System.out.println(ex.getMessage()+"区域业绩查询");
}
return list;
}

[loveyt]

nvl是Oracle特有的函数吧?

[darkhorse001]

我是想asp的代码改成jsp，下面是原文件
===============================
bdate_y=trim(Request.Form ("bdate_y"))
bdate_m=trim(Request.Form ("bdate_m"))
bdate_d=trim(Request.Form ("bdate_d"))
edate_y=trim(Request.Form ("edate_y"))
edate_m=trim(Request.Form ("edate_m"))
edate_d=trim(Request.Form ("edate_d"))
j_y_b=trim(Request.Form ("j_y_b"))
j_m_b=trim(Request.Form ("j_m_b"))
j_d_b=trim(Request.Form ("j_d_b"))
j_y_e=trim(Request.Form ("j_y_e"))
j_m_e=trim(Request.Form ("j_m_e"))
j_d_e=trim(Request.Form ("j_d_e"))
custid=UCase(trim(Request.Form ("custid")))
itemid=trim(Request.Form ("itemid"))
salep=trim(Request.Form ("salep"))
area=Trim(request.Form("area"))
set conn_ERP=server.CreateObject("adodb.connection")
set cmd=server.CreateObject("adodb.command")

conn_ERP.Open "Provider=OraOLEDB.Oracle;Password=apps;Persist Security Info=True;User ID=apps;Data Source=prod_11"
set cmd.ActiveConnection=conn_ERP

cmd.CommandText="add_cust_oe"
cmd.commandType=4
cmd.Prepared = true

cmd.Parameters.Append cmd.CreateParameter("@p_sale_b",135,1 )
cmd.Parameters.Append cmd.CreateParameter("@p_sale_e",135,1 )


cmd("@p_sale_b")= (bdate_y+"-"+bdate_m+"-"+bdate_d)
cmd("@p_sale_e")= (edate_y+"-"+edate_m+"-"+edate_d)


cmd.Execute()
'response.write cmd

str="SELECT nvl(b.ATTRIBUTE1,'未划分区域') as area,a.ACCOUNT_NUMBER,b.PARTY_NAME,sum(qty) as qty_m,sum(a.PRICE) as price_m"
str= str & " FROM nbadd.add_cust_oe_price A,TT_WMS_CUST_A b"
str= str & " where a.ACCOUNT_NUMBER = b.ACCOUNT_NUMBER"
str= str & " and b.ORG_ID = 42"
str=str &"and (nvl(b.ATTRIBUTE1,'未划分区域') ='"& area &"' Or '"&area&"' is null)"
str= str & " AND (A.ACCOUNT_NUMBER = '"& custid &"' OR '"& custid &"' IS NULL)"
str= str & " AND (A.CROSS_REFERENCE = '"& itemid &"' OR '"& itemid &"' IS NULL)"
str= str & " AND (A.NAME = '"& salep &"' OR '"& salep &"' IS NULL)"
str= str & " GROUP BY nvl(b.ATTRIBUTE1,'未划分区域') ,A.ACCOUNT_NUMBER,b.PARTY_NAME"
str= str & " order by nvl(b.ATTRIBUTE1,'未划分区域'),a.ACCOUNT_NUMBER"

set rs=Server.CreateObject("ADODB.Recordset")
rs.open str,conn_ERP,1,3

[darkhorse001]

是的