iskompajlirati, javilo mi je gresku u naslovu teme.
Dajem kod koji sam napisao:
Code:
declare
tabela varchar2(30):='PREDAVACI';
type RK is ref cursor;
im varchar2(20);
prez varchar2(30);
kur rk;
upit varchar2(100):='select ime, prezime from ' || tabela || ' where id=1';
begin
open kur for upit;
fetch kur into im, prez;
:block3.text_item8:=im;
:block3.text_item12:=prez;
close kur;
end;
declare
tabela varchar2(30):='PREDAVACI';
type RK is ref cursor;
im varchar2(20);
prez varchar2(30);
kur rk;
upit varchar2(100):='select ime, prezime from ' || tabela || ' where id=1';
begin
open kur for upit;
fetch kur into im, prez;
:block3.text_item8:=im;
:block3.text_item12:=prez;
close kur;
end;
Ali, kada sam ovaj isti kod napisao u stored proceduri u mojoj bazi, sve je radilo...
Sta da uradim da bih isti kod mogao koristiti u mom forms builderu...?
there's something out there
waiting for us,
and it ain't no man...
waiting for us,
and it ain't no man...