使用:SQL> alter procedure [your procedure name here] compile; SQL> show errors...能够从结果...
您不能在IDE中使用execute-它是一个sql*plus命令。它可能在Oracle SQL Developer中工作,但我不会在那...
**connection**.execute( `execute **viewSystemUsers**;`, (err, result) => { if(err){ console.error(err); return; } console.log(result); 我收到[错误:ORA-00900:无效的SQL语句]{errorNum:900,偏移量:0}。有人能帮我修一下吗?非常感谢你。 execute不是SQL关键字—它是SQL*Plus命令。所以数据...
您不能在IDE中使用execute-它是一个sql*plus命令。它可能在Oracle SQL Developer中工作,但我不会在那...
However, I end up facing ORA-00900 problem. Surprisingly when I execute the results independently using execute immediate then it works fine. Let's create 2 tables:create table a ( name varchar2 (100), age integer ); insert into a values ('Tom', 1); commit; insert into a values ('...
I create procedure which call procedure inside another. I have an error ORA-00900: invalid SQL statement. CREATE OR REPLACE PROCEDURE AP_MOVE_OUT is BEGIN EXECUTE IMMEDIATE 'AP_MOVEOUT_COUNT(''GNW-M2'',to_date(''2020-11-02'',''yyyy-MM-dd''),to_date(''2020-11-06'',''yyyy-MM-...
Flyway throws ORA-00900: invalid SQL statement when we have an / preceding a EXECUTE command. The script below is correctly executed in any sql program, but not in flyway migration. If i remove the /, the command executes successfully. CREATE OR REPLACE PROCEDURE set_right_value_for_sequence...
楼主应该是在PLSQL Developer 中执行吧?在这里是不能直接执行存储过程的 必须在dos下 或linux下才可以 希望解决了楼主的问题,不懂随时来问我
create or replace PROCEDURE "PD_CUSTOMER" ( p_VERSION IN CUSTOMER.VERSION%TYPE,p_CUSTOMERID IN CUSTOMER.CUSTOMERID%type ) IS BEGIN DELETE FROM CUSTOMER WHERE CUSTOMERID = p_CUSTOMERID and VERSION= p_version; END ; <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:...
直接call不就可以了啊 call p_stu();如果在PLSQL里面执行的话,SQL窗口用CALL 命令窗口用 你写得execute我都测试了没问题 SQL> execute p_stu;PL/SQL procedure successfully completed SQL>