scott@ORA92> create table valuti
  2    (sifra char(3),
  3  	oznaka char(3))
  4  /

Table created.

scott@ORA92> insert into valuti values ('978', 'abc')
  2  /

1 row created.

scott@ORA92> CREATE OR REPLACE PROCEDURE DajOznakaVal
  2    (p_valuta IN INTEGER)
  3  AS
  4    v_oznaka valuti.oznaka%TYPE;
  5  BEGIN
  6    SELECT oznaka INTO v_oznaka FROM valuti WHERE sifra = p_valuta;
  7    DBMS_OUTPUT.PUT_LINE (v_oznaka);
  8  END DajoznakaVal;
  9  /

Procedure created.

scott@ORA92> SHOW ERRORS
No errors.
scott@ORA92> SET SERVEROUTPUT ON
scott@ORA92> EXECUTE Dajoznakaval (978)
abc

PL/SQL procedure successfully completed.