you cannot assign a single value to multiple variables at once as you are trying. There are languages that allow this but PL/SQL is not one of them
JNewMember wrote: > I have created fallowing function > create or replace function check_salary(empNum in number, eNewSalary > number) > return number > is > eOldSalary number; > begin > select sal into eOldSalary from emp where empno = empNum; > if eOldSalary > eNewSalary then > return -1; > else > return 1; > end if; > end check_salary; > / > > and I tried to execute the function like this, > > SQL> variable salary number; > SQL> variable eNumber number; > SQL> exec :eNumber, :salary := check_salary(7934, 1); > BEGIN :eNumber, :salary := check_salary(7934, 1); END; > > But I end up with the fallowing error. > > * > ERROR at line 1: > ORA-06550: line 1, column 15: > PLS-00103: Encountered the symbol "," when expecting one of the > following: > := . ( @ % ; indicator > The symbol "; was inserted before "," to continue. > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
