Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting ORA-00920: invalid relational operator For Merge Statement

Vemula MuniSep 9 2019 — edited Sep 20 2019

Hi All,

I am getting the ORA-00920: invalid relational operator message foe the below query. Please help on this.

MERGE INTO PS_CT_IQN_ACC_STG STG USING PS_CTS_IQN_BU_RATE RT ON (STG.BUSINESS_UNIT = RT.BUSINESS_UNIT)

WHEN MATCHED THEN

  UPDATE

  SET STG.STANDARD_RATE      = RT.STANDARD_RATE,

    STG.STANDARD_HOURS      = RT.HOURS_PER_DAY,

    STG.CURRENCY_CD          = RT.CURRENCY_CD

  WHERE STG.PROCESS_INSTANCE = 22195604

  AND RT.EFFDT               =

    (SELECT MAX(RT1.EFFDT)

    FROM PS_CTS_IQN_BU_RATE RT1

    WHERE RT.BUSINESS_UNIT = RT1.BUSINESS_UNIT

    AND RT1.EFFDT          <= sysdate

    )

  AND STG.STANDARD_RATE      = 0 

  AND STG.STANDARD_HOURS  = 0

  AND STG.BUSINESS_UNIT IN

    ( SELECT DISTINCT BUSINESS_UNIT FROM PS_CTS_IQN_BU_RATE

    );

This post has been answered by mNem on Sep 9 2019
Jump to Answer

Comments

843807
I put your code into my system and it worked like a charm.
specified a PDF file - and Acrobat opened it with out a murmur.


What kind of file are you trying to open and are you sure its application is associated (and what OS?) - I am on Vista.

Rudi
843807
Running Win XP

Following your example, I tried a pdf file, which is obviously associated with acrobat, with the same result (ie nothing)
If I purposely misspell the file name, then I get an IllegalArgumentException saying the file doesn't exist.
So that tells me that it is finding the file (when spelled correctly), but somehow not doing anything with it.

Running the demo here:
http://java.sun.com/developer/technicalArticles/J2SE/Desktop/javase6/desktop_api/
the browse and mail functionality works, but not the file functionality, again same result, just nothing.

I'm running these from Eclipse. Would an IDE interfere with the Desktop?
camickr
The code below does nothing.
Your right it does nothing because it doesn't compile.

For more help create a [SSCCE (Short, Self Contained, Compilable and Executable, Example Program)|http://sscce.org], that demonstrates the incorrect behaviour. Then you can hardcode the filename to be the java source file name so everybody is testing the same code.
843807
package desktopdemo;

import java.awt.Desktop;
import java.io.File;
import java.io.IOException;

public class MyDesktopDemo {

	public MyDesktopDemo() {

		// have tried .txt, .rtf, .pptx all with no effect
		String pathAndFileString = "C:\\my.pptx";
		File file = new File(pathAndFileString);
		if (Desktop.isDesktopSupported()) {
			Desktop desktop = Desktop.getDesktop();
			if (desktop.isSupported(Desktop.Action.OPEN )) {
				try {
					System.out.println("desktop.open(" + pathAndFileString + ")"); // gets here
					desktop.open(file); // but nothing happens
				} catch (IOException e1) {
					e1.printStackTrace();
				}
			}
			else {
				System.out.println("Desktop.Action.OPEN not supported");
			}
		}
		else {
			System.out.println("Desktop not supported");
		}

	}

    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MyDesktopDemo();
            }
        });
    }
    
}
darrylburke
Your code runs fine and opens a text file in Windows7 and also in virtualized WinXP Mode over Win7.

db
darrylburke
Note: This thread was originally posted in the Swing forum, but moved to this forum for closer topic alignment.
darrylburke
Also, whyever are you wrapping the constructor call in invokeLater(...)? there are no Swing components involved here.

db
843807
sorry, that was just a leftover from copy/paste of another test program.
Thanks for running the code. I guess that means there is something "wrong" with this computer.
1 - 8

Post Details

Added on Sep 9 2019
2 comments
516 views