how to execute stored procedure in oracle

[Oracle]-[show_space and show_space_asm]-Run the Stored Procedure show_space and show_space_asm to report errors. Sys creates show_space () and show_space_asm (). Bisal execution prompt: SQL> exec show_space('MY_OBJECTS', 'BISAL');BEGIN show_space('MY_OBJECTS', 'BISAL'); END; *ERROR at line 1:ORA-06550: line 1, column 7:PLS-00201: identifier 'SHOW_SPACE' must be declaredORA-06550: line 1, column 7:PL/S

is the select t.bis_project_id from Bis_project t;--Define cursor variablesCur_pidscur_proids%rowtype;V_MONTHVARCHAR2 (2);V_YEARVARCHAR2 (4);Begin/**forjack.liu on 20150331*/Select To_char (sysdate, ' yyyy ') into V_yearfrom dual;Select Case Whensubstr (To_char (sysdate, ' mm '), "0" then substr (To_char (sysdate, ' mm '), 2,1) Else To_char (Sysdate, ' MM ') end into v_month from dual;--Start traversalFor Cur_pids in Cur_proids loopInsertinto zzz_test (Id,name,create_time) VALUES (V_month, ' pk

Oracle calls the stored procedure to execute a small DEMO of CRUD ------- Modify (Table Name, primary key ID, column to be modified) create or replace procedure pro_code_edit (p_tbname in varchar2, p_ct_id in varchar2, p_codename in varchar2) as p_str varchar2 (400 ); begin p_str: = 'update' | p_tbname | 'set codename

How to automatically execute the oracle stored procedure every day and call the stored procedure with the joboracle timer 1. create a table. To see the running status of the timer clearly, create a table SQL code with a date field: create table job_table (run_time date); www.2cto.com create table job_table (run_time da

Ant executes the Oracle stored procedure, the same Oracledll Script: the error indicates that the end of a row does not exist Ant executes the Oracle stored procedure, the same Oracle dll script: the error indicates that the end of a row does not exist The same

Employees.last_name%TYPE;6Emp_sal employees.salary%TYPE;7 BEGIN8Query_emp (206, emp_name,emp_sal);9Dbms_output.put_line ('Name:' ||emp_name);TenDbms_output.put_line ('Salary:' ||emp_sal); One END; A - --command line Execution (ii) -VARIABLE NAMEVARCHAR2( -) theVARIABLE Sal Number - EXECUTEQuery_emp (206,: Name,:sal);--In Out type parameter--Parameter transmission mode1. Location Transfer2. Name Transfer Name=>value3. Mixing mode (up to)1 CREATE OR REPLACE PROCEDUREadd_dept2 (3NAMEinchDepartmen

ORACLE stored procedure details, oracle Stored ProcedureORACLE Stored Procedure explanation 1. Definition A Stored Procedure is a set of SQL statements used to complete specific database functions. The SQL statement set is compiled and Stored in the database system. When usi

Loop For... in... LOOP -- Execute the statement End LOOP; (1) looping cursor Copy the Code as follows: Create or replace procedure test () Cursor cursor is select name from student; name varchar (20 ); Begin For name in cursor LOOP Begin Dbms_output.putline (name ); End; End LOOP; End test; (2) traverse arrays cyclically Copy the Code as follows: Create or replace

statement to traverse a cursor in several ways. FOR rec IN cur_1 LOOPUPDATE table nameSET RMB _amt_sn = rec. RMB _amt_sn, usd_amt_sn = rec. usd_amt_snWHERE area_code = rec. area_codeAnd cmcode = rec. CMCODEAND ym = is_ym;End loop; COMMIT; -- Error handling section. OTHERS indicates any errors except declarations. SQLERRM is a built-in variable that saves detailed information about the current error. EXCEPTION WHEN OTHERS THENVs_msg: = 'error IN xxxxxxxxxxx_p ('| is_ym |'): '| SUBSTR (SQLERRM,

Entity Framework 4.1 has been used in the project recently, and all statement queries are completed using LINQ and lambda expressions. However, several page queries are complex, when multiple condition summaries and column values are used for judgment, if writing statements using LINQ is rather complicated, it may not be able to achieve the desired results. In the end, you can only select the Oracle stored procedu