Hi,
When you try to open your chrome web explorer, if you get “Your profile could not be opened correctly” error, try to following solution:
There are several solutions on the web for this, but this is the easiest way:
-Close Chrome
-Go to “C:\Users\[user]\AppData\Local\Google\Chrome\User Data”
-Delete “Web Data” and “Web Data-journal” files. (If you cannot delete it, restart computer)
-Open Chrome
Here is the scenario;
-Type something to combobox
-Select something on the list
-Search and fill gridPanel
-Clear combobox and then search again
-It fills gridPanel with value that before we cleared.
I this this is a bug.
If you use Ext.getCmp(‘myCombo’).getValue() or Ext.getCmp(‘myCombo’).lastSelectionText, it does not work.
You have to use Ext.getCmp(‘myCombo’).getRawValue(). This works 
By the way comboBox is not readonly.
Quick Hint:
When you try to debug java code in eclipse, if you get “Source not found.” error with red letters. Here is the solution:
Down Arrow Icon Next to Debug Icon > Debug Configurations > Classpath Tab > Add Projects to User Entries
Add your project that cannot debug to this location.
If you have a web page with full of your copyrighted photos and do not want to visitors to save images in (easy way!) to their local computers. Let me show a trick about it.
In the photo (img) section of the page, we have always something like as following;
<img id="myImg"
src="http://www.google.com.tr/logoyapsana/images/templates/google_logo_01.gif"
width="667" height="472"
style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px;">
</img>
On the image, when we right-click to the mouse and click to “Save Image As” command, we can save the image to our local disk. However, if we create a basic css style with a div below of the image, we can prevent this.
The important thing is in here: blank/point image’s dimensions has to be same with original image dimensions and css class of the component should include the following properties.
.BlankPixel {
position: absolute;
top: 0;
left: 0;
}
<div id="Photo">
<img id="myImg"
src="http://www.google.com.tr/logoyapsana/images/templates/google_logo_01.gif"
width="667" height="472"
style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px;">
</img>
</div>
<div class="BlankPixel"><a href="#"><img src="http://akdora.files.wordpress.com/2011/04/point.gif" width="667" height="472"></a></div>
That’s it. This trick is an only basic measure for basic internet users. If someone want to save the photo, since the resource is downloaded to your computer to show up on the screen. It can be saved in any way.
Here is the full html example:
Copy the code and create a html page called “a.html” and open it. Try to save Google logo and see what happens 
A file dialog box will ask you a location to save “http://akdora.files.wordpress.com/2011/04/point.gif” file! Not Google Logo!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>My Title</title>
<style type="text/css">
.BlankPixel {
position: absolute;
top: 0;
left: 0;
}
</style>
</head>
<body>
<div id="Photo" class="Photo">
<img id="myImg"
src="http://www.google.com.tr/logoyapsana/images/templates/google_logo_01.gif"
width="667" height="472"
style="border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px;">
</img>
</div>
<div class="BlankPixel"><a href="#"><img src="http://akdora.files.wordpress.com/2011/04/point.gif" width="667" height="472"></a></div>
</body>
</html>
Recently, I developed a program that reads imdb.com web page for a specific movie and downloads movie info and images. Then, it merges the thumbnails images into one image file.
Firstly, I write the main code, that downloads the image files and merges them and save the merged image to system.
Note 1: In the code, arr variable is an ArrayList holds the picture urls.
Note 2: Image class is in “System.Drawing”
Image[] images = new Image[arr.Length];
for (int k = 0; k < arr.Length; k++){
images[k] = Utils.DownloadImage(arr[k]);
}
Image mergedImage = Utils.MergeImages(images);
if (mergedImage != null)
{
mergedImage.Save(fileFolder + "\\" + movieTitle + " Thumbnails.jpg");
}
Here is inside of DownloadImage function:
/// <summary>
/// Function to download Image from website
/// </summary>
/// <param name="_URL">URL address to download image</param>
/// <returns>Image</returns>
public static Image DownloadImage(string _URL)
{
Image _tmpImage = null;
try
{
// Open a connection
System.Net.HttpWebRequest _HttpWebRequest = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(_URL);
_HttpWebRequest.AllowWriteStreamBuffering = true;
// set timeout for 20 seconds (Optional)
_HttpWebRequest.Timeout = 20000;
// Request response:
System.Net.WebResponse _WebResponse = _HttpWebRequest.GetResponse();
// Open data stream:
System.IO.Stream _WebStream = _WebResponse.GetResponseStream();
// convert webstream to image
_tmpImage = Image.FromStream(_WebStream);
// Cleanup
_WebResponse.Close();
}
catch (Exception _Exception)
{
// Error
Console.WriteLine("Exception caught in process: {0}", _Exception.ToString());
return null;
}
return _tmpImage;
}
Here is inside of MergeImages function:
/// <summary>
/// Merges Images into 1 Image.
/// </summary>
/// <param name="images">The Images you want merge</param>
/// <returns>An Image of all images</returns>
public static Image MergeImages(Image[] images)
{
if (images == null || images.Length <= 0)
{
return null;
}
Int32 imageWSize = 0;
Int32 imageHSize = 0;
for(int i=0;i<images.Length;i++)
{
if (images[i].Width > imageWSize)
imageWSize = images[i].Width;
if (images[i].Height > imageHSize)
imageHSize = images[i].Height;
}
Int32 width = 0;
Int32 height = 0;
int picsInOneLine = 10;
if (images.Length >= picsInOneLine)
{
width = picsInOneLine * imageWSize;
decimal d = (images.Length + picsInOneLine) / picsInOneLine;
height = (int)Math.Round(d) * imageHSize;
}else{
width = images.Length * imageWSize;
height = imageHSize;
}
Bitmap bitmap = new Bitmap(width, height);
int hhh = -1;
int www = 0;
for(int i=0; i<images.Length; i++)
{
Bitmap image = new Bitmap(images[i]);
if (i % picsInOneLine == 0)
{
hhh++;
www = 0;
}
//Get All of the x Pixels
for (int w = 0; w < imageWSize; w++)
{
//Get All of the Y Pixels
for (int h = 0; h < imageHSize; h++)
{
//Set the Cooresponding Pixel
int ww = w + (www * imageWSize);
int hh = h + (hhh * imageHSize);
bitmap.SetPixel(ww, hh, image.GetPixel(w, h));
}
}
www++;
}
//Return the new Bitmap
return bitmap;
}
If you changed your computer and want “your PL/SQL developer login history and preferences” as well in your new computer. Copy the following folder to your new computer in the same path format!
C:\Users\[username]\AppData\Roaming\PLSQL Developer
If you need only the login history, open the following file:
C:\Users\[username]\AppData\Roaming\PLSQL Developer\Preferences\[username]\user.prefs
In the file, copy [LogonHistory] part to your new user.prefs file. It’s encrypted but it does not matter. PL/SQL Developer will dencrypt it
I need this, because I deal with a lots of database with a lots of schema.. It is really hard to remember the passwords sometimes, so i let the PL/Developer to remember them (Preferences > Login History > Store with Password)
When we try to rename table or index name in Oracle, we use a simple command as following;
alter table [prev_table_name] rename to [last_table_name]
If we put into schema names to this command, we can deal with ORA-14047 error. This error raise when we put schema name in front of the last_table_name.
alter table hr.[prev_table_name] rename to hr.[last_table_name] >>> RAISES ORA-14047 ERROR alter table hr.[prev_table_name] rename to [last_table_name] >> CORRECT ONE
It is same with Index renaming.
I experienced that when you connect to Oracle database from shell and get some data from the table, if the length of the column value is more than 80 letters. Shell puts space in every 80th letter automaticly. I do not know why, but it is really interesting. I counted the number 80 for my environment. It may differ in different systems.
Anyway, I need to remove that interesting spaces. So here is a script to do this.
RETVAL=`echo $RETVAL | sed 's/ //g'`
We use the SED command. Its use like ‘s/[seach_letter]/[replacement]/g’. In my example [seach_letter] is ” ” space and [replacement] is nothing. For example; If we want to replace ” ” (space) characters with “_” (underscore) character. Here is how we do this:
RETVAL=`echo $RETVAL | sed 's/ /_/g'`
I wrote this quick entry, because if you do not remember how to do something like this and want to google it. It is not easy to find sometimes
#################################################################################
#!/bin/ksh
##################################################################################
# Filename: test.sh
# Name : Özay Akdora (http://akdora.wordpress.com)
# Date : 04.03.2011
# Purpose : Oracle - Shell Integration (SQL Operations & PL/SQL Execution )
# Env : This example is uses Oracle 11G with "/export/home/oracle/app/product/11.2c" path and korn shell script
# First of all we need to define some variable to access Oracle Database
export ORACLE_HOME=/export/home/oracle/app/product/11.2c
export LD_LIBRARY_PATH=/export/home/oracle/app/product/11.2c/lib
export PATH=/usr/local/bin:/usr/local/sbin:/usr/bin:/export/home/oracle/app/product/11.2c/bin:/export/home/ubtool/ubSQL_5.0.1:
# Then, we need to define username/password (@ optional another database TNS definition).
export db_connection_url=scott/tiger@MYDB
# I needed to connect to another database to query a table that has my configuration data.
# Your shell code may locate in an another machine that you want to connect.
# Anyway, You have to define TNS info of MYDB database to /export/home/oracle/app/product/11.2c/network/admin/tnsnames.ora
# You have to give permission to execute this file. For example : chmod 777 test.sh
# You also have to give permission, if you put this file to a folder that you created new.
# Run as : "./test.sh"
#######################################################################
# Let's see what we got here;
# Example 1: Access db and query SYSDATE:
echo "########## Example 1: SYSDATE ############"
RETVAL=`sqlplus -s $db_connection_url <<EOF
select to_char(sysdate,'dd.mm.yyyy hh24:mi:ss') my_date from dual;
exit;
EOF`
echo $RETVAL
# As you see, we connected to database with sqlplus command ( We defined it's path to PATH above.
# Then we set username and password with $db_connection_url variable
# After that, we tell the command line execute what you see between EOF words :) (Note: You can use ENDASDKAJSDK instead of EOF ) :)
# Finally, we set the date to $RETVAL variable and prints it to screen.
# Let me explain that : Think like this way. We are using SQLPLUS (in any environment) and executing some commands and getting some result on the screen
# In this example; We set everything to $RETVAL that we see the results of sqlplus screen. Everything!
#######################################################################
# Example 2 : SQLCODE
echo "########## Example 1: SQLCODE ############"
RETVAL=`sqlplus -s $db_connection_url <<EOF
whenever sqlerror exit sql.sqlcode;
select to_char(sysdate,'dd.mm.yyyy hh24:mi:ss') my_date from dual;
exit;
EOF`
ERROR_CODE=$?
#Let me check the error code.
if [ $ERROR_CODE != 0 ]
then
echo "There are some errors. ErrorCode: $ERROR_CODE";
else
echo "Command executes successfully. ErrorCode: $ERROR_CODE";
fi
echo $RETVAL
#######################################################################
# Example 3 : SQL(Select) with WHERE clause
echo "########## Example 3: SQL with WHERE clause ############"
#Declare the variable
feed_id=1;
RETVAL=`sqlplus -s $db_connection_url <<EOF
set feed off echo off head off
select * from extract_external_feeds where feed_id='$feed_id';
exit;
EOF`
#echo $RETVAL
v_result=`echo -n $RETVAL|awk '{printf $4}'`
echo $v_result
# Let's see what we done here.
# We added "set feed off echo off head off " line to command. So, I do want to see column names as result.
# In (feed_id='$feed_id') section do not forget to use (').
# We writes (awk '{printf $3}') the data of third column in my table.
# Note: We assumes that the data in the columns do not have any space like " " space :)
#######################################################################
# Example 4 : SQL(Select) with WHERE clause & Multiple Variables
echo "########## Example 4: SQL with WHERE clause ############"
#Declare the variable
feed_id=1;
RETVAL=`sqlplus -s $db_connection_url <<EOF
set feed off echo off head off
select ROW_LINE from EXTRACT_EXTERNAL_FEEDS_VW where feed_id='$feed_id';
exit;
EOF`
#echo $RETVAL
var1=`echo -n $RETVAL|awk -F\# '{printf $1}'`
var2=`echo -n $RETVAL|awk -F\# '{printf $2}'`
var3=`echo -n $RETVAL|awk -F\# '{printf $3}'`
echo $var1
echo $var2
echo $var3
# Since, I do want to make query for each column value, I return them with and deliminater like "#". The we parse it with awk command in shell.
# SELECT FEED_ID, FILE_PATH, MAIN_PATH, DB_VIEW_NAME FROM EXTRACT_EXTERNAL_FEEDS
#
# CREATE OR REPLACE VIEW EXTRACT_EXTERNAL_FEEDS_VW AS
# SELECT FILE_PATH || '#' || MAIN_PATH || '#' || DB_VIEW_NAME AS ROW_LINE, FEED_ID
# FROM EXTRACT_EXTERNAL_FEEDS
#######################################################################
# Example 5 : SQL (Select) with dynamic column names
echo "########## Example 5 : SQL (Select) with dynamic column names ############"
feed_id=1;
column_name='DB_VIEW_NAME';
RETVAL=`sqlplus -s $db_connection_url <<EOF
set feed off echo off head off
select $column_name from EXTRACT_EXTERNAL_FEEDS where feed_id='$feed_id';
exit;
EOF`
echo $RETVAL
# We can pass variables to SQLPLUS commands like ($column_name)
#######################################################################
# Example 6 : Calling PL/SQL
echo "########## Example 6 : Calling PL/SQL ############"
RETVAL=`sqlplus -s $db_connection_url <<EOF
var x number ;
exec pk_my_package.prc_my_proc(1,1,:x);
print x;
exit;
EOF`
echo $RETVAL
# We can call PL/SQL codes as we work in SQLPLUS and read the outputs
#######################################################################
# Example 7 : Calling Dynamic PL/SQL
echo "########## Example 7 : Calling Dynamic PL/SQL ############"
dynamicCode1="declare v_date date; begin select sysdate into v_date from dual; dbms_output.put_line(to_date(v_date,'dd.mm.yyyy hh24:mi:ss') ); end; ";
dynamicCode2="
var x varchar2(2000);
exec prc_my_proc;
print x;";
RETVAL=`sqlplus -s $db_connection_url <<EOF
set serveroutput on;
$dynamicCode2
exit;
EOF`
echo $RETVAL
# We can also set dynamic variable that contains PL/SQL commands, but you have to set the variable with new lines to execute them successfully.
# If you set the variable like $dynamicCode1. The code does not work. You have to do it as $dynamicCode2. You may read this code from an config file or oracle table.
#######################################################################
# Finally, if we want to do fancy. The following is a way one can describe this script as Oracle job.
#
# BEGIN
# DBMS_SCHEDULER.CREATE_PROGRAM(PROGRAM_NAME => 'akdora_test',
# PROGRAM_TYPE => 'EXECUTABLE',
# PROGRAM_ACTION => '/export/home/bonjovi/ozay/test.sh',
# NUMBER_OF_ARGUMENTS => 0,
# ENABLED => TRUE,
# COMMENTS => 'Fantasy Program');
# END;
# /
#
#
#
# I hope this entry is helpful for you.
# Cheers
After I read some blog entries about exporting Excel files via PL/SQL recently, I also decided to share my Excel API code in PL/SQL. I wrote a similar article before . This API has following features;
Most of the interface procedures accepts SQL query as parameter:
DECLARE
MYEXCELCONTENT CLOB;
BEGIN
-- Test statements here
PK_EXCEL_API.G_SHOW_BORDER := 'Y';
PK_EXCEL_API.EX_EXCEL_OPEN(MYEXCELCONTENT);
PK_EXCEL_API.EX_WORKSHEET_OPEN(MYEXCELCONTENT, 'test');
PK_EXCEL_API.EX_ROW_OPEN(MYEXCELCONTENT);
PK_EXCEL_API.EX_CELL_WRITE(MYEXCELCONTENT, 'asdasdasd');
PK_EXCEL_API.EX_ROW_CLOSE(MYEXCELCONTENT);
PK_EXCEL_API.EX_ROW_OPEN(MYEXCELCONTENT);
PK_EXCEL_API.EX_CELL_WRITE(MYEXCELCONTENT, 'INVOICE NUMBER');
PK_EXCEL_API.EX_CELL_WRITE(MYEXCELCONTENT, 'SEQ NO');
PK_EXCEL_API.EX_CELL_WRITE(MYEXCELCONTENT, 'VERSION..');
PK_EXCEL_API.EX_CELL_WRITE(MYEXCELCONTENT, 'BLA BLA BLA');
PK_EXCEL_API.EX_ROW_CLOSE(MYEXCELCONTENT);
PK_EXCEL_API.EX_WORKSHEET_CLOSE(MYEXCELCONTENT);
PK_EXCEL_API.EX_EXCEL_CLOSE(MYEXCELCONTENT);
PK_EXCEL_API.PRC_WRITE_EXCEL_FILE(P_CLOB => MYEXCELCONTENT,
P_FILENAME => 'test.xls',
P_DIR => 'UTL_FILE_DIR');
END;
Here is the all package here: PK_EXCEL_API_v1.0
(Note:Since I could not upload directly txt files to wordpress, I put the code into a odt file and uploaded here)
