PROCEDURE Llena_Lista_Mon eda IS
BEGIN
Clear_List('Blo ck2.moneda');
For Reg In ( Select Mon_Cod,Mon_Des From Tgen_moneda Order by 1) Loop
Begin
Add_List_Elemen t('Block2.moned a',1, Reg.mon_des, Reg.Mon_cod);
End;
End Loop;
END;
Alixandro Florian Cuevas
Last Activity: May 23 '07, 02:49 PM
Joined: Aug 31 '06
Location: Dominican Republic
-
Dear Richa
a function only return one value, only accep parameters IN not IN OUT or OUT.
eg. Create or Replace Function Richa (var1 number, var2 in varchar2) Return Date, Varchar2 or number.
example.
[code=oracle]
Create Or Replacr Function Telephone(Perso nID number) Return Varchar2 Is
Cursor tel is
Select tel_telefono telefono
from tcli_telefono
where...Leave a comment:
-
dear Mrs
1- Install oracle81 into default home (ej. C:\Oracle)
2- Install Developer 6i into diferent home (ej. C:\Oracle\Dev6i or C:\Dev61)
3- Go to C:\Oracle\Net80 \Admin and copy Tnsname.ora, Sqlnet.ora To C:\Oracle\Dev61 \Net80\Admin or C:\Dev6i\Net80\ Admin
Alixandro Florian
Dominican Republic.Leave a comment:
No activity results to display
Leave a comment: