Oracle数据库job，调用存储过程，PLSQL工具执行后，没有报错，但是也没有任何效果，哪位大神帮忙分析一下
sql> createorreplaceproceduretest_jobproceas2 3 begin4 5 insertIntotest_jobvalues（sysdate）؛ 6 7 ENDTEST_JOBPROC; 8 9 /警告：创建过程在汇编中存在错误。sql> dandrors; ourdretest_jobproce错误事件：线/colerorm ------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- -------------------------------------------------------------------------- --------------------------------------------------------------------------- ---------------------------------------------------------------------------- ------- ------------------------------------------或提供不存在的SQL> CreateEtablest_job（t1 date）sql> createorRereplaceProuseDureTest_jobProceas2 3 begin4 5 insrtintotest_jobvals（sysdate）; 6 7 ENDTEST_JOBPROC; 8 /创建了过程。
sql> crectest_job_relynumber; 2 begin3 dbms_job.submit（test_job_real，'test_jobprocs;'，sysdate，'sysdate+1 /1 4 4 0'）sql> rpitn：test_job_real; SP2 -07 3 4 ：它以“ rpitn：tes ”开始未知 - 剩下的线被忽略。
SQL>打印：test_job_real; SP2 -05 5 2 ：尚未公布限制的变量“ test_job_rely”。
sql> descdba_jobs; ----------------------------------------------------------------------------- --------------------------------------------------------------------------- --------------------------------------------------------------------------- ------------------------------------------------------------------------------------- ------------------------------------------------------------------------------ ----------------------------------------------------------------------------------- -------------------------------------------------------------------------- --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- --------------------- 3 0）last_datedatelast_secvarchar2 （8 ）this_dateThis_secvarchar2 （8 ）next_datenotnulldatenext_secvarchrcarcarcar2 （8 ）tocul_timenumbrokentvarchcar2 （1 ）instanceNumbrokenvarchcar2 （1 ）2 ） 工作 - - - - - - - - - - - - - - - - - - - - - - - - - ------------------------------------------------------------------------------- -------------------------------------------------------------------------- -------------------------------------------------------------------------- -------------------------------------------------------------------------- ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- ------- flow_platform。
3 test_jobroce; 工作 - - - - - - - - - - - - - - - - - - - - - - - - - -------------------------------------------------------------------------- -------------------------------------------------------------------------- -------------------------------------------------------------------------- -------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------> execdbms_job.run（3 ）; PL/SQL过程已成功完成。
sql>选择*fromtest_job2 ; t1 ------------------------------------------1 4 05 -March-1 4 sql>/t1 ----------------------------------------------------------------------------------- -------------- 05 -March-1 4 05 -March-1 4 Sql>/T1 ------------------------------------------------------------------1 4 05 -march-march-1 4 sql>/t1 -- ------------------------------------------------------------------------------- --------------------------------------------March-1 4 05 -March-1 4 sql> execdbms_job.run（3 ）; 成功完成。
SQL>/t1 -------------------------------------March-1 4 05 -March-1 4 05 -March-1 4 sql> T1 ---------------------------------------------------------------- - -05 -March-1 4 05 -March-1 4 05 -March-1 4 sql> execdbms_job.run（3 ）; sql>/t1 -----------------------------------March-1 4 05 -March-1 4 05 -March-1 4 05 -March-1 4 05 -March-March-1 4 05 -March-March-1 4 Sql>
背景：oracle，plsql 问题描述，在用SYSTEM执行存储过程 identifier must be declared
统一不会结束。如果您查看左侧列表上的proc，则图标上必须有x描述。
15PLSQL--函数，存储过程
4 子程序定义：Oracle规定PL/SQL程序可以存储在数据库中并在任何地方运行。这称为存储过程或函数。
过程和功能称为PL/SQL子例程，所有这些都存储在数据库中，并通过输入，输出或输入/输出参数与呼叫者交换信息。
过程和函数之间的唯一区别是该函数始终将数据返回到呼叫者，但是该过程未返回数据。
4 .1 创建函数语法：[orreplace] function function_name [（argment [{in | inout}] type，gragment [{in | out | out | inout}]其他语句是-createorreplaceFunction_demo声明函数名称 - 您必须在呼叫过程中设置一个变量 - 返回结果的数据类型是可选的，因为该函数必须返回值。
在函数中传递到函数时，该功能通过参数传递到呼叫语句。
，inuta，从一个过程中传递给该过程，并且在过程之外的过程中，参数无法分配给一个过程。
过程必须有一个变量的参数。
一个要做的方法1 方法：selectfun_test01 fromdual; ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------ --------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------ ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------- ）; callecount_empnumber：= 0 ------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------ ----------------------------------------------------------------------------- --------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------查询部门数据未添加'）; ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------; c; dbms_output.put_line（a ||'|| b）; ）dbms_output.put_line（a ||' ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- --------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ------------' - 'thento_char（a-b）'*'thento_char（a*b）='？ 'thendbms_output。
ifresult ='？ 'thenndbms_output.put_line ::::: ::::::::::::::::::::: :::::::::::::::::：:::::::: :::::: ::::::::::::: :::::::::: ::::::::::::::: ::::::::::: :::::::::::::: :::::::::::::： :::::::::::::::：::::::::::::::::: ::::::::::::::::::: :::::::::::::::：::::::::::：::::::::::::::::::: tue ::::::::::::::::::::: ::::::::::::::::：:::::::::::::::::::: :::::::::::::::：::::::::::::::::：:::::::::::::::::::: ::::::::::::::::：::::::::::::：::::::: ::::::::::::::::::::: :::::::（|'| op ||'| b ||'='||结果） ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- ---------------------------------------------------------------------------'初始值：' ||。
||'||。
oracle中怎么在plsql中调用存储过程
打开setSerserviceUtputon并请求要查看的输出。例如，有以下存储过程：createreplaceplanceprocep_testasv_begintimevarchar2 （2 0）; v_ndtimavarchar2 （2 0）; v_strvarchar2 （1 0）; ; v_endtime：= to_char（sysdate，'yyy -m -ddhh2 4 ：mi：ss'）; dbms_output.put_line（'开始时间为：'|| v_begintime）; dbms_output.put_line（'最后时间是：'|| v_ndi me）; 结尾;
shell脚本里怎样调用plsql存储过程？
我对存储的了解不多，但是我可以以这种方式调用Orak SQLP。＃cat sql.sh＃！ - - - - - - -打开
