|
-
What pinakin talking about is an anonymous PL/SQL block you have to type in SQL*PLUS to test your function.
Other problems with your function:
If you want to display the annual salary the way you want, define a cursor. Use a cursor for loop to fetch into v_annsal and use
dbms_output('give_me'||v_annsal);
inside the loop to see your output.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|