tag:blogger.com,1999:blog-18037024.post1111967485304823908..comments2024-02-16T14:33:11.277+01:00Comments on Annals of Oracle's Improbable Errors: PLS-00323 and PLS-00593Byte64http://www.blogger.com/profile/15629209362377395020noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-18037024.post-52670617904333398062013-03-08T23:46:09.982+01:002013-03-08T23:46:09.982+01:00Thanks !Thanks !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-46222061838566818502013-02-19T20:48:54.668+01:002013-02-19T20:48:54.668+01:00Thanks you!
2. the input/output (in/out) declarati...Thanks you!<br />2. the input/output (in/out) declaration is different<br />You have been Google plused :) ishekhttps://www.blogger.com/profile/07257596885630952007noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-3468298416039744622012-02-29T02:54:50.348+01:002012-02-29T02:54:50.348+01:00For the love of God thank you!!! I was testing us...For the love of God thank you!!! I was testing using IN OUT instead of just IN, and forgot to update the package body where I defined the procedure. Caused this annoying error, and I spotted it after an hour of hair pulling thanks to your post.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-79142030521878054932011-07-28T14:39:00.313+02:002011-07-28T14:39:00.313+02:00Thanks for this. I guess practically every Oracle ...Thanks for this. I guess practically every Oracle coder has stubbed their toes on this one. How much lost coding time has this caused and how much value has the strict functionality created? Methinks that Oracle could improve their system by allowing different names and allowing forward declaration automatically!Recombinant Sockshttps://www.blogger.com/profile/10981573106238238007noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-47267036021715837142011-06-03T14:33:54.949+02:002011-06-03T14:33:54.949+02:00Thanks a lot for the post.And u have written the e...Thanks a lot for the post.And u have written the exact thought that is going on in mind after getting the error msg...:):). Again thanks a lot..:)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-11284669043413562942011-05-27T09:12:49.891+02:002011-05-27T09:12:49.891+02:00It really helped me.. thanks for the blog :)
@GEQ...It really helped me.. thanks for the blog :)<br /><br />@GEQ<br />thanks for your mentiong that difference in the *names* caused the error. I faced the same and now it is resolvedAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-13563030720269095692010-01-22T19:14:25.111+01:002010-01-22T19:14:25.111+01:00Thanks. I just could not see it - never did. A cop...Thanks. I just could not see it - never did. A copy and paste fixed it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-73855145572440485932009-10-21T23:05:22.563+02:002009-10-21T23:05:22.563+02:00With your help, it was simple. Thanks! I'd bee...With your help, it was simple. Thanks! I'd been looking at this crazy thing for about an hour. Fixed is less than a minute with your explanation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-72694448057859004992009-09-28T22:51:56.309+02:002009-09-28T22:51:56.309+02:00Thank you so much. I spent an hour wondering what ...Thank you so much. I spent an hour wondering what was wrong when I have already defined the procedureAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-67405749458315543872009-06-17T19:32:00.815+02:002009-06-17T19:32:00.815+02:00Bless you child. The different parameter name got ...Bless you child. The different parameter name got me. Thanks for your help. I was going nuts.Unknownhttps://www.blogger.com/profile/12972574060967218607noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-63520252488234756332008-09-19T16:48:00.000+02:002008-09-19T16:48:00.000+02:00Briliant!!10 coffies saved!Thank You man!Briliant!!<BR/><BR/>10 coffies saved!<BR/>Thank You man!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-29119539273755853682008-08-19T10:56:00.000+02:002008-08-19T10:56:00.000+02:00ThanksNow i know that there is a differnce between...Thanks<BR/>Now i know that there is a differnce between P1_varible and PI_varible.<BR/>:-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-10479446281285808942008-07-18T23:37:00.001+02:002008-07-18T23:37:00.001+02:00Thank You very much for the usful blog. It really ...Thank You very much for the usful blog. It really saved my time!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-63021964371548984682008-07-18T23:37:00.000+02:002008-07-18T23:37:00.000+02:00Thank You very much for the usful blog. It really ...Thank You very much for the usful blog. It really saved my time!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-79852461627269340942008-06-06T17:01:00.000+02:002008-06-06T17:01:00.000+02:00Thanks a lot of the information. Still getting use...Thanks a lot of the information. Still getting used to the huge number of differences between Oracle and SQL Server. Fortunately, I have been able to keep the "scream therapy" internal so far.<BR/><BR/>GeorgeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-89596618057926243472008-04-21T16:25:00.000+02:002008-04-21T16:25:00.000+02:00Thanks for this :)I was literally scratching my he...Thanks for this :)<BR/>I was literally scratching my head for this!!!Sabyasachi Mukherjeehttps://www.blogger.com/profile/04459662520963253374noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-70298658694760586782008-01-28T07:02:00.000+01:002008-01-28T07:02:00.000+01:00Thanks for your post. I didn't expect oracle to be...Thanks for your post. I didn't expect oracle to behave in such a way. Anyhow, you saved me from banging my head against the wall. To put it simply, just copy ur parameter argument from package specification to package body. This will eliminate all fuss..Happy coding..Kaneko Shinobuhttps://www.blogger.com/profile/03400789238753091495noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-24557806700930719452007-09-27T09:45:00.000+02:002007-09-27T09:45:00.000+02:00Doug,concerning the second problem you report, tha...Doug,<BR/>concerning the second problem you report, that's the way it works unless you adopt the so-called <I>forward declaration</I> method.<BR/>There is an excellent explanation of this method in <A HREF="http://awads.net/wp/2007/04/30/two-oracle-plsql-features-you-probably-don%E2%80%99t-know-about/" REL="nofollow">Eddie Awad's blog</A>.<BR/><BR/>Thank you,<BR/>FlavioByte64https://www.blogger.com/profile/15629209362377395020noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-29679144117409323762007-09-27T01:16:00.000+02:002007-09-27T01:16:00.000+02:00Correction to previous post - I did get PLS-00323,...Correction to previous post - I did get PLS-00323, not PLS-00230.Unknownhttps://www.blogger.com/profile/15758548244055733849noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-87474323919056779012007-09-27T01:14:00.000+02:002007-09-27T01:14:00.000+02:00Thank you for posting this information! I encount...Thank you for posting this information! I encountered PLS-00230 today and found your blog, and after getting my head around the real meaning of the message, I discovered ANOTHER way that the error can be raised (as a result of my coding). When a procedure or function references other function(s) in a package, the spec and body of the referenced function(s) must appear prior to the procedure or Unknownhttps://www.blogger.com/profile/15758548244055733849noreply@blogger.comtag:blogger.com,1999:blog-18037024.post-24652951616754803552007-08-31T19:33:00.000+02:002007-08-31T19:33:00.000+02:00Thank you very much! I spent several hours scream...Thank you very much! I spent several hours screaming "I have declared it!" Fortunately I found your blog before I pulled out any hair.<BR/><BR/>-BillAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-18037024.post-20263489620213278852007-03-16T20:28:00.000+01:002007-03-16T20:28:00.000+01:00Bless you! I spent a day trying to find out what w...Bless you! I spent a day trying to find out what was wrong with my code.<BR/>I never imagined that different *names* of variables between the spec and the body would cause this error.<BR/>Thanks again.Geoff Quelchhttps://www.blogger.com/profile/08837261915082820468noreply@blogger.com