当前位置: 代码迷 >> Oracle管理 >> ora 创建存储过程报错,该怎么处理
  详细解决方案

ora 创建存储过程报错,该怎么处理

热度:33   发布时间:2016-04-24 05:26:44.0
ora 创建存储过程报错
SQL code
create or replacePROCEDURE "P_PXPAPER_HIS_INSERT"(      PARAM_HIS_ID IN OUT VARCHAR2,    PARAM_SCORE IN NUMBER := NULL,    PARAM_NUMBER IN NUMBER := NULL,    PARAM_PAPER_ID IN VARCHAR2 := NULL,    PARAM_USERID IN VARCHAR2 := NULL,    PARAM_MEMO IN VARCHAR2 := NULL,    PARAM_CREATE_TIME IN DATE := SYSDATE  )ASBEGIN    IF ISNULLOREMPTY(PARAM_HIS_ID)=1 THEN    SELECT GET_CURRENT_SERVER_ID || '-' || "SEQ_PXPAPER_HIS".NEXTVAL INTO PARAM_HIS_ID FROM DUAL; ELSE    --保持原来值    PARAM_HIS_ID:=PARAM_HIS_ID; END IF; INSERT INTO "PXPAPER_HIS"(    "HIS_ID","SCORE","NUMBER","PAPER_ID","USERID","MEMO","CREATE_TIME" ) VALUES (    PARAM_HIS_ID,PARAM_SCORE,PARAM_NUMBER,PARAM_PAPER_ID,PARAM_USERID,PARAM_MEMO,PARAM_CREATE_TIME );END;/create or replacePROCEDURE "P_PXPAPER_HIS_DELETE"(    PARAM_HIS_ID VARCHAR2)    ASBEGIN    DELETE FROM "PXPAPER_HIS"    WHERE        "HIS_ID" = PARAM_HIS_ID;END;/


错误信息:ORA-24344: success with compilation error

Procedure execution failed
ORA-06550: line 1, column 38:
PLS-00905: object VIVE_WM.P_PXPAPER_HIS_INSERT is invalid
ORA-06550: line 1, column 28:
PL/SQL: Statement ignored

查询时间: 0.047ms

帮帮忙呗,很郁闷,不知道怎么回事

------解决方案--------------------
你是sqlserver转ORACLE ?

DELETE FROM "PXPAPER_HIS"
WHERE
"HIS_ID" = PARAM_HIS_ID;
改成
DELETE "PXPAPER_HIS"
WHERE
"HIS_ID" = PARAM_HIS_ID;

------解决方案--------------------
把过程名上面的引号去掉!
  相关解决方案