{"id":22231,"date":"2024-03-15T23:13:54","date_gmt":"2024-03-15T23:13:54","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/"},"modified":"2024-03-21T22:23:07","modified_gmt":"2024-03-21T22:23:07","slug":"how-to-call-an-oracle-stored-procedure-in-perl","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/","title":{"rendered":"How to call an Oracle stored procedure in Perl?"},"content":{"rendered":"<p>To call an Oracle stored procedure using Perl, you can connect to the Oracle database using the DBI module and execute the stored procedure using the prepare and execute methods.<\/p>\n<p>Below is an example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">use<\/span> DBI;\r\n\r\n<span class=\"hljs-keyword\">my<\/span> $dsn = <span class=\"hljs-string\">'DBI:Oracle:host=HOSTNAME;sid=SID'<\/span>;\r\n<span class=\"hljs-keyword\">my<\/span> $username = <span class=\"hljs-string\">'USERNAME'<\/span>;\r\n<span class=\"hljs-keyword\">my<\/span> $password = <span class=\"hljs-string\">'PASSWORD'<\/span>;\r\n\r\n<span class=\"hljs-comment\"># \u8fde\u63a5\u5230Oracle\u6570\u636e\u5e93<\/span>\r\n<span class=\"hljs-keyword\">my<\/span> $dbh = DBI-&gt;<span class=\"hljs-keyword\">connect<\/span>($dsn, $username, $password) <span class=\"hljs-keyword\">or<\/span> <span class=\"hljs-keyword\">die<\/span> <span class=\"hljs-string\">\"\u65e0\u6cd5\u8fde\u63a5\u5230\u6570\u636e\u5e93: $DBI::errstr\"<\/span>;\r\n\r\n<span class=\"hljs-comment\"># \u5b9a\u4e49\u5b58\u50a8\u8fc7\u7a0b\u7684\u8c03\u7528\u8bed\u53e5<\/span>\r\n<span class=\"hljs-keyword\">my<\/span> $sql = <span class=\"hljs-string\">'BEGIN your_procedure_name(:param1, :param2); END;'<\/span>;\r\n\r\n<span class=\"hljs-comment\"># \u51c6\u5907\u6267\u884c\u5b58\u50a8\u8fc7\u7a0b<\/span>\r\n<span class=\"hljs-keyword\">my<\/span> $sth = $dbh-&gt;prepare($sql) <span class=\"hljs-keyword\">or<\/span> <span class=\"hljs-keyword\">die<\/span> <span class=\"hljs-string\">\"\u65e0\u6cd5\u51c6\u5907\u5b58\u50a8\u8fc7\u7a0b: $DBI::errstr\"<\/span>;\r\n\r\n<span class=\"hljs-comment\"># \u7ed1\u5b9a\u5b58\u50a8\u8fc7\u7a0b\u7684\u53c2\u6570<\/span>\r\n<span class=\"hljs-keyword\">my<\/span> $param1 = <span class=\"hljs-string\">'value1'<\/span>;\r\n<span class=\"hljs-keyword\">my<\/span> $param2 = <span class=\"hljs-string\">'value2'<\/span>;\r\n$sth-&gt;bind_param(<span class=\"hljs-string\">':param1'<\/span>, $param1);\r\n$sth-&gt;bind_param(<span class=\"hljs-string\">':param2'<\/span>, $param2);\r\n\r\n<span class=\"hljs-comment\"># \u6267\u884c\u5b58\u50a8\u8fc7\u7a0b<\/span>\r\n$sth-&gt;execute() <span class=\"hljs-keyword\">or<\/span> <span class=\"hljs-keyword\">die<\/span> <span class=\"hljs-string\">\"\u65e0\u6cd5\u6267\u884c\u5b58\u50a8\u8fc7\u7a0b: $DBI::errstr\"<\/span>;\r\n\r\n<span class=\"hljs-comment\"># \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5<\/span>\r\n$dbh-&gt;disconnect();\r\n<\/code><\/pre>\n<p>Please update the hostname, username, password, stored procedure name, and parameters in the sample code according to the actual situation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To call an Oracle stored procedure using Perl, you can connect to the Oracle database using the DBI module and execute the stored procedure using the prepare and execute methods. Below is an example code: use DBI; my $dsn = &#8216;DBI:Oracle:host=HOSTNAME;sid=SID&#8217;; my $username = &#8216;USERNAME&#8217;; my $password = &#8216;PASSWORD&#8217;; # \u8fde\u63a5\u5230Oracle\u6570\u636e\u5e93 my $dbh = DBI-&gt;connect($dsn, [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-22231","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to call an Oracle stored procedure in Perl? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to call an Oracle stored procedure in Perl?\" \/>\n<meta property=\"og:description\" content=\"To call an Oracle stored procedure using Perl, you can connect to the Oracle database using the DBI module and execute the stored procedure using the prepare and execute methods. Below is an example code: use DBI; my $dsn = &#039;DBI:Oracle:host=HOSTNAME;sid=SID&#039;; my $username = &#039;USERNAME&#039;; my $password = &#039;PASSWORD&#039;; # \u8fde\u63a5\u5230Oracle\u6570\u636e\u5e93 my $dbh = DBI-&gt;connect($dsn, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T23:13:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T22:23:07+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"How to call an Oracle stored procedure in Perl?\",\"datePublished\":\"2024-03-15T23:13:54+00:00\",\"dateModified\":\"2024-03-21T22:23:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\"},\"wordCount\":64,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\",\"name\":\"How to call an Oracle stored procedure in Perl? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T23:13:54+00:00\",\"dateModified\":\"2024-03-21T22:23:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to call an Oracle stored procedure in Perl?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to call an Oracle stored procedure in Perl? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/","og_locale":"en_US","og_type":"article","og_title":"How to call an Oracle stored procedure in Perl?","og_description":"To call an Oracle stored procedure using Perl, you can connect to the Oracle database using the DBI module and execute the stored procedure using the prepare and execute methods. Below is an example code: use DBI; my $dsn = 'DBI:Oracle:host=HOSTNAME;sid=SID'; my $username = 'USERNAME'; my $password = 'PASSWORD'; # \u8fde\u63a5\u5230Oracle\u6570\u636e\u5e93 my $dbh = DBI-&gt;connect($dsn, [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T23:13:54+00:00","article_modified_time":"2024-03-21T22:23:07+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"How to call an Oracle stored procedure in Perl?","datePublished":"2024-03-15T23:13:54+00:00","dateModified":"2024-03-21T22:23:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/"},"wordCount":64,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/","name":"How to call an Oracle stored procedure in Perl? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T23:13:54+00:00","dateModified":"2024-03-21T22:23:07+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-call-an-oracle-stored-procedure-in-perl\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to call an Oracle stored procedure in Perl?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=22231"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22231\/revisions"}],"predecessor-version":[{"id":56142,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22231\/revisions\/56142"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=22231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=22231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=22231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}