亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 請(qǐng)教：關(guān)于oracle 9I wrap命令的編譯錯(cuò)誤 [打印本頁(yè)]

作者: gqj100 時(shí)間: 2005-02-06 11:43
標(biāo)題: 請(qǐng)教：關(guān)于oracle 9I wrap命令的編譯錯(cuò)誤
UPDATE H_KM SET DJKM = (
                        SELECT (SELECT DECODE(COUNT(*)-1,0,1,0)
                                          FROM H_KM t
                                          WHERE KM       LIKE m.KM||'%' AND
                                                ZTBM    = v_ZTBM       AND
                                                DEPARTCODE = v_DEPARTCODE
                                 )
                           FROM H_KM m
                           WHERE ZTBM    = v_ZTBM       AND
                                 DEPARTCODE = v_DEPARTCODE  AND
                                 KM       = H_KM.KM
                        )
   WHERE ZTBM    = v_ZTBM       AND
         DEPARTCODE = v_DEPARTCODE  ;
這段程序在Package中運(yùn)行時(shí)沒(méi)有問(wèn)題的，但是wrap的時(shí)候卻不能通過(guò)
我懷疑9I 的wrap采用的語(yǔ)法還是oracle7下面的，因?yàn)閛racle7不支持這種語(yǔ)法，其實(shí)就是view中套一個(gè)view，
9I下面編譯錯(cuò)誤信息：
PL/SQL Wrapper: Release 9.0.1.1.1- Production on Sun Feb 06 11:30:30 2005

Copyright (c) Oracle Corporation 1993, 2001.  All Rights Reserved.

Processing CWCODE.PCK to CWCODE.plb
PSU(103,1,281,37):Encountered the symbol "SELECT" when expecting one of the following:

( - + case mod not null others <an identifier>;
<a double-quoted delimited-identifier>; <a bind variable>; avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>;
<a number>; <a single-quoted SQL string>; pipe

PSU(103,1,286,37):Encountered the symbol "

" when expecting one of the following:

. ( * @ % & - + ; / at for mod rem <an exponent (**)>; and or
group having intersect minus order start union where connect
||

哪位朋友能否指點(diǎn)一下，是不是oracle的wrap程序有問(wèn)題？感覺(jué)wrap的編譯語(yǔ)法還是oracle7似的

歡迎光臨 Chinaunix (http://72891.cn/)