Oracle Error Ora-01797
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the oracle error ora 01797 this operator must be followed by any or all company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions database error ora-01797 this operator must be followed by any or all Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million ora-01843 programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA 01797- operator must be followed by any or all up vote 0 down vote favorite I am testing a ora-00907 condition like this in the where clause of a subquery. But I am getting the error "operator must be followed by any or all" when I execute the SSRS report. dbase is oracle. And i need to use IN with parameter because the parameter in SSRS report is multivalued. I am using a separate function to generate dates that go in :P_Date. I need to check if this date is = or <
Any Sql
or null . All three conditions need to be tested. where trunc(tt.fyh_fecha) IN (:P_Date) OR trunc(tt.fyh_fecha) <(:P_Date) OR trunc(tt.fyh_fecha) IS NULL AND tc.cod_tree = 'blue' AND tt.color_flower = 'pink' reporting-services oracle11g subquery share|improve this question asked Apr 29 '14 at 22:59 user3587184 612 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote This doesnt seem directly possible - you are trying to use a parameter containing an array of values against the < operator which only expects one value. Your design doesnt make any logical sense to me either (<= multiple dates?), but anyway ... I would add a join to a Calendar / Date Dimension table, where I would apply the IN (:P_Date) criteria to get a list of Date values as a deliberate cross join. Then I would replace: trunc(tt.fyh_fecha) IN (:P_Date) OR trunc(tt.fyh_fecha) <(:P_Date) OR with: trunc(tt.fyh_fecha) <= Dim_Date.Date_Value share|improve this answer answered Apr 30 '14 at 3:06 Mike Honey 8,6191720 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the a
b. add any before multiple value like = any (1, 2) reference: http://oraclequirks.blogspot.com/2008/06/ora-01797-this-operator-must-be.html Posted
Ora-00933
by Benjamin Li at 2:59 PM Email ThisBlogThis!Share to TwitterShare sql all to FacebookShare to Pinterest 1 comment: Mz_VelocityApril 7, 2016 at 7:07 AMTHANKS, THIS HELPED ReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Followers Blog Archive ► 2014 (6) ► October (1) ► July (1) ► June (2) http://stackoverflow.com/questions/23376798/ora-01797-operator-must-be-followed-by-any-or-all ► January (2) ► 2013 (25) ► November (1) ► October (4) ► September (1) ► August (1) ► July (2) ► May (4) ► April (2) ► February (8) ► January (2) ▼ 2012 (140) ► December (4) ► November (12) ▼ October (15) configure new service on oracle database recovery http://benjamindba.blogspot.com/2012/10/ora-01797-this-operator-must-be.html file dest in Oracle database Encountered unrecognized patch ID: Z6MQ -- Oracle ... Run job in background and not terminated after log... Perl regular expression match Alertlog Error Filter in Oracle Cloud Control enable \n for echo linux command Variable/Parameter Substitution in Shell Script STATISTICS ( STATS) collection job in oracle hostname of redhat linux in AMI oracle s3 cloud module installation and check ORA-01797: this operator must be followed by ANY o... rman catalog view Useful linux command shutdown linux command ► September (7) ► August (12) ► July (12) ► June (17) ► May (15) ► April (7) ► March (15) ► February (12) ► January (12) ► 2011 (46) ► December (7) ► November (21) ► October (13) ► September (3) ► July (2) ► 2010 (12) ► November (2) ► October (1) ► September (5) ► August (4) About Me Benjamin Li View my complete profile Simple template. Powered by Blogger.
Messages: 138Registered: June 2000 Senior Member In one of my application I am getting the following error, Could any body throw http://www.orafaq.com/forum/t/14337/ some light on this error. I do not have nay further info on this, as this is executable I can not fetch the query also, Basically which http://codigocentral.com/ora-01797-this-operator-must-be-followed-by-any-or-all/ operator must be followed by ANY or ALL ORA-01797: this operator must be followed by ANY or ALL Thanks and best regards, Srinivas Report message to a moderator error ora Re: ORA-01797 [message #40619 is a reply to message #40618] Wed, 23 October 2002 09:05 Rick Cale Messages: 111Registered: February 2002 Senior Member My guess the sql statement(s) need to be corrected in the source code then recompiled/linked which is the responsibility of the vendor or whoever fixes code. You need to report oracle error ora the problem to the vendor. Rick Report message to a moderator Previous Topic: Is it possible to have a package inside package Next Topic: sql question Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Sun Oct 23 12:30:00 CDT 2016 Total time taken to generate the page: 0.05108 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.
ALL Cause: The keyword ANY or ALL was missing. Action: Check the statement syntax and add ANY or ALL where appropriate. Back to previous menu Share this:Click to email this to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Pocket (Opens in new window) ORA-01797 Post navigation Previous PostORA-01796: this operator cannot be used with listsNext PostORA-01798: missing EXCEPTION keyword The Path Technology Home Database Oracle All Oracle Error Code Family ALL EXP-CODE LIST ALL IMP-CODE LIST ALL ORA-CODE LIST ALL NZE-CODE LIST Tracks Oracle Error Code Family ALL EXP-CODE TRACKS ALL IMP-CODE TRACKS ALL ORA-CODE TRACKS ALL NZE-CODE TRACKS Oracle Utilities SQL Server SQL Server Configuration Manager Operational Systems AIX LINUX WINDOWS Systems ERP - Enterprise Resource Planning SAP All SAP Transactions SAP Errors and Alerts Search for: Proudly powered by WordPress Translate » Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! Email check failed, please try again Sorry, your blog cannot share posts by email.