Oracle Scribble

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-2816220435408464&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-2816220435408464 -->

</head><body>*/</style>

ORA-12638: credential retrieval failed - Solved

ORA-12638: credential retrieval failed - Solved

Oracle Forms unable to connect to the database and returns the error ORA- 12638: credential retrieval failed. Not much to explain, you can...

Sree 15 Sept, 2022

Toad to Oracle 19c cloud Connection

Configuration , Connection wallet , Oracle 19 C Cloud

Toad to Oracle 19c cloud Connection

Connecting to Oracle 19c Cloud Database from client machine needs to use the connection wallet. In this blog we will be downloading and u...

Sree 25 Aug, 2022

Showing QR Code in Oracle Reports. Generation of QR Code using PL/SQL and showing it in Oracle Reports.

Configuration , Generate QR code , Oracle Forms and reports

Showing QR Code in Oracle Reports. Generation of QR Code using PL/SQL and showing it in Oracle Reports.

In this blog, we will be generating a qr code using pl/sql and then the code will be shown in our oracle reports. Requirement. Generate a QR...

Sree 16 Aug, 2022 6

Create QR Code in Oracle Database. Pure PLSQL code.

Configuration , Generate QR code , pl-sql

Create QR Code in Oracle Database. Pure PLSQL code.

To View how we generate a qr code from db and shown in the report, look here . In this blog, we will be Generating QR code from our Oracle d...

Sree 15 Aug, 2022

Create alias / Virtual directory in oracle 12c OHS – Open server files using web_show_document in Oracle 12 c -

Configuration , Oracle 12 C , Oracle Forms and reports

Create alias / Virtual directory in oracle 12c OHS – Open server files using web_show_document in Oracle 12 c -

In this section we will be creating a alias for a folder in our oracle forms 12 c server so that we can access the files in that folder from...

Sree 13 Aug, 2022

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/91768132-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4m1fw77qWipC1J5uiNmVlf5XaQJw:1737015204978';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d5395993054747432138','//oraclescribble.blogspot.com/','5395993054747432138');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '5395993054747432138', 'title': 'Oracle Scribble', 'url': 'https://oraclescribble.blogspot.com/', 'canonicalUrl': 'https://oraclescribble.blogspot.com/', 'homepageUrl': 'https://oraclescribble.blogspot.com/', 'searchUrl': 'https://oraclescribble.blogspot.com/search', 'canonicalHomepageUrl': 'https://oraclescribble.blogspot.com/', 'blogspotFaviconUrl': 'https://oraclescribble.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en-GB', 'localeUnderscoreDelimited': 'en_gb', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Oracle Scribble - Atom\x22 href\x3d\x22https://oraclescribble.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Oracle Scribble - RSS\x22 href\x3d\x22https://oraclescribble.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Oracle Scribble - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/5395993054747432138/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-2816220435408464', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/d2c988fc3a56b1b1', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en_GB\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'pageName': '', 'pageTitle': 'Oracle Scribble'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard', 'ok': 'Ok', 'postLink': 'Post link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Oracle Scribble', 'description': '', 'url': 'https://oraclescribble.blogspot.com/', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': true, 'isArchive': false, 'isLabelSearch': false}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost1', 'postId': '6543135544312184495'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '6543135544312184495', 'title': 'ORA-12638: credential retrieval failed  - Solved', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEjEGf0ECAoDnU84B0WFejL8OmiSA-ICpXwB6m2Zxliq3XaUWuue2rO5zj1tBdukU3Igz8utq73R4RFpzflPnG_Ntd24PZJecs2JDQdJk8iBnPcEXFfzyDwAwXPSYTB6toKQWfZ8XMtBNIrovzdRicm3PTa0peTeMbyx-hCHrIw-uCUoO6-3FrUH-xJ3_Q\x3dw485-h170', 'showInlineAds': false}, {'id': '8400432863521669615', 'title': 'Toad to Oracle 19c cloud Connection', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5sKLOZ00T2M7JBEOQ8eT3chLl7Cri-o54COYZ5ncElnPAlInQR6pSfjHfp82_A3e3zDgFnwRltKOHK086SwMDnwvJJ_jGtKNdQS7VeuExlxaV_79dVls_H9YutAT_ktpuai6BdC9ot3uECpN9a2sCfpgj0hc6rWwq8VHISLdPM1x_nEO_otYBi5fTsQ/w629-h602/Toad%20Connection%20To%20Oacle19c.jpg', 'showInlineAds': false}, {'id': '2710553235823482569', 'title': 'Showing QR Code in Oracle Reports. Generation of QR Code using PL/SQL and showing it in Oracle Reports.', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUgChu2uIpB20R_kDZ7eKOCbkQeNrN2j_fiOD60vyVeeHRn_ukzpVsX-jUjrDwEGem4vVat7J5WAHwTFZhYUTW52EmqLbauLZ0X6EvIRsGBoqhjCDAs6SOQ0STUZtFIJRNvjlei4PYiLdJ2m_BOsiGNtu7SvAEOE337x9vim35OvH08SE-yAqXxxx6iQ/w492-h470/Cover.png', 'showInlineAds': false}, {'id': '7702510058514910894', 'title': 'Create QR Code in Oracle Database. Pure PLSQL code.', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhOse9PyCLm9tMi2jSb4DKcniysTEfkx4VTgiIogLXmmBnI195SvSmtyOcUCyajRlusmFXPcDVWfdT5AC6EulsbzG_KyYE_BTlsFmEzxx6D7Y9ptV2YUMdo7546Tt_8rFqUU8RxSwV3B_BxMVV0lx09tSwqX5SNhBfgmIkgbwiLlDC5La6eVDZ1jfpEQ/w522-h500/Cover.png', 'showInlineAds': false}, {'id': '257367361736313064', 'title': 'Create alias / Virtual directory in oracle 12c OHS \u2013 Open server files using web_show_document in Oracle 12 c - ', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR4VrSVXZtAwc1dYeGkKHlOLN99vRwisJg8aACCwcft1IMhCe2eemcZToSmc0eRu9-7F1dwj972cJO57pqWEc6zK4IkSLcNkeXpshNF6QJ2PMITbpXUDOX1GWZ8jKVI4yJjCbMAczuopV0gYzY_Ziq9jArG3yC1U0NR3wS8hX5R6mM9OZKzWW7CW753w/s320/Cover.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags:'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Tags:'}]}, {'title': '', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML9'}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Create QR Code in Oracle Database. Pure PLSQL code.', 'id': 7702510058514910894}, {'title': 'Create alias / Virtual directory in oracle 12c OHS \u2013 Open server files using web_show_document in Oracle 12 c - ', 'id': 257367361736313064}, {'title': 'Showing QR Code in Oracle Reports. Generation of QR Code using PL/SQL and showing it in Oracle Reports.', 'id': 2710553235823482569}, {'title': 'Toad to Oracle 19c cloud Connection', 'id': 8400432863521669615}, {'title': 'REP-56133 \u2013 an attempt to write to the folder failed due to lack of permission Oracle forms and report 12c - Unable to generate report to file \u2013 Solved', 'id': 8463363199413801471}]}, {'title': 'Facebook', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML25'}, {'title': 'Subscribe to our YouTube Channel', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML26'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML19'}, {'title': '', 'type': 'ReportAbuse', 'sectionId': 'sidebar-static', 'id': 'ReportAbuse1'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'before-blog', document.getElementById('FeaturedPost1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3812250239-lbx__en_gb.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML9', 'sidebar-static', document.getElementById('HTML9'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML25', 'sidebar-static', document.getElementById('HTML25'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML26', 'sidebar-static', document.getElementById('HTML26'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML19', 'sidebar-static', document.getElementById('HTML19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ReportAbuseView', new _WidgetInfo('ReportAbuse1', 'sidebar-static', document.getElementById('ReportAbuse1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>