Solved

Debugging with Boolean values:Wrong number or types of arguments in call to '||'

Posted on 2009-04-02
2
279 Views
Last Modified: 2013-12-18
When I use a boolean value with DBMS_OUTPUT.PUT_LINE is get an error.

Error is "Wrong number of types of arguments in call to '||'

This is because DBMS_OUTPUT package is not overloaded for boolean values.

How can I debug boolean values in Pl/Sql then?

***********code***********
Procedure process (p_trade_no IN number,
                   p_ellig_in IN BOOLEAN) AS

BEGIN
      DBMS_OUTPUT.PUT_LINE('value of p_ellig_in is '||p_ellig_in );
      IF p_ellig_in THEN
            null;
      END IF;

END;

Error: Wrong number or types of arguments in call to '||'
0
Comment
Question by:gram77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Milleniumaire earned 500 total points
ID: 24048930
Try the following:

Procedure process (p_trade_no IN number,
                   p_ellig_in IN BOOLEAN) AS

BEGIN
  DBMS_OUTPUT.PUT_LINE('value of p_ellig_in is '||CASE when p_ellig_in then 'Y' else 'N' END);
      IF p_ellig_in THEN
            null;
      END IF;

END;
0
 

Author Closing Comment

by:gram77
ID: 31565747
Simple Solution For A Complex Problem!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem with duplicate records in Oracle query 16 52
Oracle Query - Return results based on minimum value 8 44
Oracle collections 15 39
Database Design Dilemma 6 65
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

749 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