Code:
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'INSERT_KANDIDAT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
java.lang.Exception
at KandidatDB.insert(KandidatDB.java:28)
at TestKandidatDB.main(TestKandidatDB.java:12)
Press any key to continue . . .
java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00306: wrong number or types of arguments in call to 'INSERT_KANDIDAT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
java.lang.Exception
at KandidatDB.insert(KandidatDB.java:28)
at TestKandidatDB.main(TestKandidatDB.java:12)
Press any key to continue . . .
Pomenuta funkcija je definisana kao:
Code:
FUNCTION INSERT_KANDIDAT(p_jmbg IN kandidat.jmbg%TYPE, p_ime IN kandidat.ime%TYPE, p_prezime IN kandidat.prezime%TYPE, p_sifra_skole IN kandidat.sifra_skole%TYPE, p_oslobodjen IN BOOLEAN, p_svedocanstva IN lista_svedocanstva) RETURN NUMBER;
FUNCTION INSERT_KANDIDAT(p_jmbg IN kandidat.jmbg%TYPE, p_ime IN kandidat.ime%TYPE, p_prezime IN kandidat.prezime%TYPE, p_sifra_skole IN kandidat.sifra_skole%TYPE, p_oslobodjen IN BOOLEAN, p_svedocanstva IN lista_svedocanstva) RETURN NUMBER;
Kada iz koda i procedure izbacim pojavljivanje parametra p_oslobodjen funkcija se izvrsi bez greske. Da li je neko imao ovakav problem (i kako ga je resio) ??
Owl