?
Solved

How to get rid of warning messages while compiling Oracle Procedure

Posted on 2011-04-24
2
Medium Priority
?
595 Views
Last Modified: 2012-05-11
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
Comment
Question by:toooki
2 Comments
 
LVL 4

Accepted Solution

by:
devind earned 1900 total points
ID: 35458054
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
 

Author Comment

by:toooki
ID: 35462632
Thank you.
I used ALTER SESSION SET PLSQL_WARNINGS='DISABLE:ALL';.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question