example
Posted April 15th, 2010 by admin
First PLSQL procedure
Connect to sqlplus
insert this code to sql shell:
CREATE OR REPLACE procedure giorgio(var in varchar2) is
contenent number(20);
BEGIN
select test_id into contenent from test where test_id= var;
dbms_output.put_line(contenent);
END;
/
now try to execute the your first procedure:
sql>set serveroutput
sql>exec giorgio()
