Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace
- PROCEDURE CIKK_ADATAI
- (
- I_CSZAM in int,
- O_CNEV OUT varchar2,
- o_me out varchar2,
- o_ear out number
- ) AS
- hany number;
- BEGIN
- select count(*) into hany
- from cikk
- where cikkszam=i_cszam;
- if hany = 0 then
- dbms_output.put_line ('Nincs ilyen számú cikk!');
- else
- select cikknev, m_egyseg, egysegar
- into o_cnev, o_me, o_ear
- from cikk
- where cikkszam=i_cszam;
- end if;
- END CIKK_ADATAI;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement