• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • Last Modified:

How to get rid of warning messages while compiling Oracle Procedure

I have an Oracle procedure with this line in it:
--In declaration
retval                         PLS_INTEGER;

--In Begin End block
retval := DBMS_LDAP.UNBIND_S(my_session);

I do not need to use the variable retval but is needed for calling the above unbind function.
I get warning message when compiling:
Compilation errors for ....

Error: Hint: Value assigned to 'retval' never used in MYPROCEDURE
Line: 211
Text: retval := DBMS_LDAP.UNBIND_S(my_session);

Is there any way to get rid of this error?
0
toooki
Asked:
toooki
1 Solution
 
devindCommented:
Either you can use variable retval in your code say for some assignment or you can turn off the plsql warning for the database.
refer
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams166.htm#REFRN10249

Example to disable all warnings
ALTER SESSION SET PLSQL_WARNINGS='DISABLE:ALL';
0
 
toookiAuthor Commented:
Thank you.
I used ALTER SESSION SET PLSQL_WARNINGS='DISABLE:ALL';.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now