Software Factory - Web Applications - Architecture Design - Consulting

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()



Donate

Last articles

User login