tag:blogger.com,1999:blog-7849367040589270673.post454604731023063082..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: PL/SQL 101: Why can't I display a Boolean value with DBMS_OUTPUT.PUT_LINE?Steven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7849367040589270673.post-54392219397184505082017-11-02T08:38:29.220-07:002017-11-02T08:38:29.220-07:00That's precisely my point, Boobal: the utility...That's precisely my point, Boobal: the utility procedure has the IF-THEN inside it so that YOU don't have to write that over and over again in your application code.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-59975395847488168702017-11-02T05:53:31.254-07:002017-11-02T05:53:31.254-07:00Hello Sir, why did you want the developers to not ...Hello Sir, why did you want the developers to not to use the IF..THEN..DBMS on the Boolean, but to use the Boolean manager? The Boolean manager must have an IF..THEN.. processing inside of it isn't it?<br /><br />Thank you,<br />Boobal GanesanAnonymoushttps://www.blogger.com/profile/06735225277182790976noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-69726013791848568612016-11-02T04:10:09.198-07:002016-11-02T04:10:09.198-07:00Excellent point, Kevan.
Don't just fix the p...Excellent point, Kevan. <br /><br />Don't just fix the problem with PUT_LINE. Fix it re: implicit conversion generally!<br /><br />When and if you can start passing a Boolean to PUT_LINE, I expect that is how the PL/SQL dev team will resolve it. 'Cause they are lots smarter than me, and maybe just maybe as smart as you. :-)Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-87485649908705417022016-11-02T04:09:02.677-07:002016-11-02T04:09:02.677-07:00Sharp eye! Added the paren.Sharp eye! Added the paren.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-68608245963517684652016-11-02T03:20:21.239-07:002016-11-02T03:20:21.239-07:00I'd prefer this overload enhancement:
create ...I'd prefer this overload enhancement:<br /><br />create or replace package standard authid definer as<br />...<br /> procedure to_char(left boolean);Kevan Gellinghttps://www.blogger.com/profile/03130867399318742175noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-90663951455161687962016-11-02T00:00:02.746-07:002016-11-02T00:00:02.746-07:00Hmmm... Last example a bit too much cut'n'...Hmmm... Last example a bit too much cut'n'paste? ;-)<br /><br />Seems to be missing a final parentheses and the correct output?<br /><br />But good points in this post ;-)Kim Berg Hansenhttps://www.blogger.com/profile/06491635470794828550noreply@blogger.com