Fatih Keles

Ranch Hand
+ Follow
since Sep 01, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
8
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Fatih Keles

Here is how your query works:

Consider n=6 then,
Select each element that has 5 other higher values then itself. Being the 6th one, there should be 5 other elements bigger than the 6th one.

This query is used to display nth best element. But the below query gives a single value.



As you said, this query is for a single element, not for top most nth elements!

Below is my test in Oracle Database


if you wish to find top N elements, you should use something like this
Hi,

Why do you interfere mysqldump file with java? -r option will direct the output to file. Remove readers and writers and just execute the process, I suppose you will see the correct content in the "/Backup/zzzzz.sql" file. msyqldump will handle it. For more options see MySQL 5.1 Reference : mysqldump

Regards,
Fatih.
Hi kessy,

Here is a sample code for you. What it does :
1) Creates a combobox
2) builds a model for combobox from items of type DemoModelItem (try commenting out overrided toString method)
3) sets combobox model

Make sure that you have visited "How to Use Combo Boxes" tutorial.

There are several way that comes to my mind
1. Why not declare 2 different cursors than use if statements to decide which cursor will be opened?
2. If you need some kind of fancy cursor declaration, you may union both SQLs (they need to select same types) and then make only one of them fetches data. Something like this

3. You may use dynamic sql with open cursor for ... using ... OPEN-FOR-USING

You may extend the list, but simple is safer so if I were you I would go for 1.
11 years ago
Hi Megha,

What is the value of "nol" variable before insert statement? It can be null and not populated by your first query. As Martin said you should debug your code, it will reveal the error.
11 years ago
Hi pankaj,

You can not just start development at home for OAF. You need a development environment for Oracle Applications (E-Business Suite ERP software). There are some well known sources in this area, and lots of useful blogs. But I am sorry you need to access an enterprise software in order to run your first OAF page from your local machine which will be developed with the correct version of JDeveloper for OAF.

First find an EBS instance that you have access and then you can develop and test your first page.

Regards,
Fatih.
11 years ago
Hi Brendan,

Can you please use proper setXXX methods for sql statements? It is not that hard and saves a lot of time when passing values to queries Here you can start.

Regards,
Fatih.
Hi DeepakN,

I am not familiar with WAS but it sounds like a driver issue. At least can you verify that your application running on WAS also uses the same version of Oracle JDBC driver as your local/standalone application does?

Regards,
Fatih.
I suppose this is mysql database, anyways, can you put 97 in single quotes to see if it works. But you should use PreparedStatement and proper setXXX methods.
Hi dhaval,

You can see full path for your java classes stored in database with the following sql statement



But I could not understand what you mean by oracle client? Is it sqlplus or toad? or some jdbc code. Can you post some sample code here?

Regards,
Fatih.
12 years ago
Hi Nishant,

You should move your cursor to the first record, then another and then another



Regards,
Fatih.
May be something like this

If I were you I would re-write my queries as one sql using right join.
Hi Mythily,

You can not just store blob pointer inputstream in memory. Either you should fetch all the bytes and store it in memory in order to use it in vInsertPhoto method (not good), or you should read some bytes and then write it immediately.

You have to merge your methods into one method that will read one row from Access DB then insert it to Oracle DB.

Regards,
Fatih.
12 years ago