This lazy weekend, while browsing for random stuff, I came across this website which allowed users to exchange likes, follow, comments for some popular social networking websites.
So, I decided to try it. To see if it actually works, I created an account on like4like.org and created one Pinterest account to verify it.
On this website, you have to give your profile link which you want others to follow, or to like. I provided my Pinterest page url, and then started following other users on Pinterest through this website.
In 2-3 minutes, I followed some 5-7 users and keenly refreshed my Pinterest page. To my surprise, I got my first follower in 4 min time. Now, I wanted to see how fast can I get followers so, I started following more users and within some 1 hour I had around 15 followers. Not Bad!
Exchanging back-links has been there for long time to improve Google page rank. And it was a successful method until one day, when Google decided to give negative score for black-hat SEO method. Well, for now this method works.
Sunday, March 16, 2014
Saturday, March 15, 2014
Html5 Game Programming Tutorial for Beginners Part 2 - Keyboard and Bullets
In this part, we will load an image object, control its movement using keyboard, and then we will arm our hero with a loaded gun.
So, time to bring our hero in picture. I will load the image saved in my local folder.
[code language="javascript"]
//create init function to initialize image loading
var img = new Image();
var imgLoaded = false;
img.onload = function() {
imgLoaded=true;
}
img.src = 'images/hero.png';
[/code]
After loading the image, we need to draw it on canvas
[code language="javascript"]context.drawImage(img,x,y);[/code]
To keep code sane, we will create hero object that will hold all properties and methods of hero. If you are new to Objects in javascript refer Working with objects
[code language="javascript"]
var hero = {
x: 50,
y: 50,
width:img.width,
height:img.height,
draw: function() {
if(imgLoaded){
context.drawImage(img,this.x,this.y);
}
}
};
[/code]
So, time to bring our hero in picture. I will load the image saved in my local folder.
Load Image
[code language="javascript"]
//create init function to initialize image loading
var img = new Image();
var imgLoaded = false;
img.onload = function() {
imgLoaded=true;
}
img.src = 'images/hero.png';
[/code]
After loading the image, we need to draw it on canvas
[code language="javascript"]context.drawImage(img,x,y);[/code]
Create Hero Object
To keep code sane, we will create hero object that will hold all properties and methods of hero. If you are new to Objects in javascript refer Working with objects
[code language="javascript"]
var hero = {
x: 50,
y: 50,
width:img.width,
height:img.height,
draw: function() {
if(imgLoaded){
context.drawImage(img,this.x,this.y);
}
}
};
[/code]
Friday, March 14, 2014
Html5 Game Programming Tutorial for Beginners Part 1 - Drawing on Canvas
I will document my learning of game programming here. I don't like writing long paragraphs so, I will just note necesary things here . Let's roll
Creating canvas
Canvas is a rectangular space on page, which is blank until you draw something on it. We can draw stuff on canvas using JS.
Now, lets go ahead and create a canvas and draw some text on it.
We can define canvas in html page or we can create it using JS function.
In HTML
[code language="html"]
<canvas id="<span class=">myCanvas" width="500" height ="300">Canvas not supported</canvas></canvas>
[/code]
and save the canvas object in JS variable
[code language="javascript"]
canvas= document.getElementById("myCanvas");
[/code]
In JS
[code language="javascript"]
var canvas = document.createElement('canvas');
canvas.id = 'myCanvas';
canvas.width = 1224;
canvas.height = 768;
[/code]
Creating canvas
Canvas is a rectangular space on page, which is blank until you draw something on it. We can draw stuff on canvas using JS.
Now, lets go ahead and create a canvas and draw some text on it.
We can define canvas in html page or we can create it using JS function.
In HTML
[code language="html"]
<canvas id="<span class=">myCanvas" width="500" height ="300">Canvas not supported</canvas></canvas>
[/code]
and save the canvas object in JS variable
[code language="javascript"]
canvas= document.getElementById("myCanvas");
[/code]
In JS
[code language="javascript"]
var canvas = document.createElement('canvas');
canvas.id = 'myCanvas';
canvas.width = 1224;
canvas.height = 768;
[/code]
Monday, October 28, 2013
Oracle Report Builder - Internal Error Code 600
While compiling program unit in report builder 6i, I got the below error message. The code is simple SQL statement like
select 1 into var from apps.wip_discrete_jobs;
ORA-00600 : internal error code, arguments [17069], [97056504], [] ,[] ..
But after changing the schema name from apps to wip the code compiled successfully.
select 1 into var from apps.wip_discrete_jobs;
ORA-00600 : internal error code, arguments [17069], [97056504], [] ,[] ..
But after changing the schema name from apps to wip the code compiled successfully.
Monday, September 9, 2013
Addiction of Social Gaming
Now a days people are just crazy about social network games. They spend whole day in virtual shops, farms, collecting virtual money to buy virtual stuff with which they achieve some goals that at last gives them, I consider, virtual pleasure.
I experienced similar thing when my brother was playing candy crush game on Facebook. Suddenly he turned to me and said
"You get married!"
"What?.. What happened suddenly?"
"I was thinking it would be easy to get approval from 3rd person to reach next level"
*To cross some levels you need approval from 3 people in candy crush game.
I experienced similar thing when my brother was playing candy crush game on Facebook. Suddenly he turned to me and said
"You get married!"
"What?.. What happened suddenly?"
"I was thinking it would be easy to get approval from 3rd person to reach next level"
*To cross some levels you need approval from 3 people in candy crush game.
Tuesday, May 14, 2013
BI / XML Publisher - Fixed number of records per page
Requirement
* Display fixed number of records per page.
* On each page, display header
* Display footer on last page
* In case if footer is spanning across pages, move one record(last record) to next page and display footer at bottom of the page.
Fig1. Pages others than last one
Fig2. Display Footer on last page
Fig 3. Special condition where footer spans across pages
Fig 4. To handle footer spanning across pages, move last record to next page and then display footer
Solution
Download complete template code
(open it and save it as rtf)
Download sample data
XML Data is of form
<ROOT>
<A>
<B1>lineB11</B1>
<B2>lineB12</B2>
<B3>lineB13</B3>
<B4>lineB14</B4>
</A>
..
..
</ROOT>
Lets quickly freshen up our XML Publisher Reports knowledge
How to declare variables?
XSL variable declaration
<? variable : a ; number(1) ?>
XML Publisher variable declaration
<? xdoxslt:set_variable($_XDOCTX,'i',1) ?>
How to use conditional logic in template?
<?if@inlines: [condition] ?> [value] <? end if ?>
Example
<?if@inlines: $a = 1 ?> Text <?end if?>
@Inline is used to print text on the same line, else its displayed on next line
How to use Looping constructs?
Looping for particular XML tag
for-each:current_group()
How to use Page Breaks?Below tags work only in Word form field. Other declarations can be entered like normal text, but this tags should be put in Word Form field tag.
<xsl:attribute name="break-after">page
<xsl:attribute name="break-before">page
Use this inside inline IF condition to give appropriate page breaks.
Now, Lets solve our problem.
1. Decide Number of lines per page : There is no formula that works for all scenarios. Number of lines that need to be displayed per page has to be decided based on
header size,
font size and
other factors.
Create a simple for-each loop in table to find out how many rows a page can accommodate and assign that value to the variable nlpp.
Lets say after the header which I have decided(refer Fig1) a page can accommodate 46 records. Declare number of lines per page in a a variable nlpp
<?variable:nlpp;number(46)?>
2. Calculate total number of lines : Total number of lines coming in data can be calculated by using count() function on particular node. Assign that value to variable TOTLINES
Consider that records are coming inside A node(refer to sample data above), like for 4 records there will be 4 A nodes present in data.
<?xdoxslt:set_variable ($_XDOCTX,'TOTLINES',count(//A))?>
this will count number of A tags coming in data, and assign that value to TOTLINES variable.
3. Page Break after every nth row : After every 46th record we want to give a page break. We decided number of records that we want per page and based on that we have to insert page breaks.
Using for-each:tag, loop through all the records
<?for-each:A?> <?B1?> <end for-each>
To keep track of count of records, we will increment variable i value using following loop
<?for-each:A?>
<?xdoxslt:set_variable($_XDOCTX,'i',xdoxslt:get_variable($_XDOCTX,'i')+1)?>
<?B1?>
<?end for-each?>
It gets the current value of i using get variable, adds 1 to that and sets new value of i.
After each nlppv(same as variable nlpp with value 46) number of records we want page break.
Check value of counter variable. When 47the record is reached give page break using xsl break-before and reset the counter variable value to 1.
<?if@inlines : xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'nlppv') + 1 ?>
<?xsl:attribute name="break-before"> page </xsl:attribute>
<?xdoxslt:set_variable($_XDOCTX,'i',1)?>
<?end if ?>
Now we have code in place to display each record column value and code to make sure that after every nth page a page break is inserted.
Just add Footer after the loop condition and when all records are processed, a footer will be displayed after it. But we need to display footer section at bottom of the page, so we need to add spaces based on some logic.
Decide Number of Blank Lines to add to display footer at bottom of the page.
The same way we decided value of variable nlpp in step 1, we need to run some test and check how many records a page can accommodate along with footer section().
<!--?xdoxslt:set_variable($_XDOCTX,'ilast',70)?>
The last IF EF condition is outside of main loop to display records.
If number of records on the page(value of variable i after loop is complete) is less that the total number of records that the last page can accommodate along with footer section(ilast value), we need to insert blank lines.
Following code will display blank lines to make sure footer appears at bottom of the page.
<?if:xdoxslt:get_variable($_XDOCTX,’i’)
< (xdoxslt:get_variable($_XDOCTX,’ilast’) - 1)?>
<?for-each:xdoxslt:foreach_number($_XDOCTX,1,xdoxslt:get_variable($_XDOCTX,'ilast') - xdoxslt:get_variable($_XDOCTX,'i'),1)?>
4. Special Scenario that need to be handled
Footer coming across pages: This scenario is for last page alone. We need to decide the number of records that can come in single page along with footer, without footer breaking across page.
Complete Code Explanation
Variable Declarations
<?variable:nlpp;number(46)?> -- number of lines that should be displayed per page before page break
<!--?xdoxslt:set_variable($_XDOCTX, 'page', 1)?> -- keeps track of page numbers
<!--?xdoxslt:set_variable($_XDOCTX, 'i', 0)?> --- variable used for looping through all records
<!--?xdoxslt:set_variable ($_XDOCTX,'nlast', (xdoxslt:get_variable($_XDOCTX,'TOTLINES') mod $nlpp)) ?> --calculate number of lines for last page
<!--?xdoxslt:set_variable($_XDOCTX, 'nlppv', $nlpp)?> --xsl variable nlpp declared above just for convenience of using short variable name
<!--?xdoxslt:set_variable ($_XDOCTX,'tpage', ceiling (xdoxslt:get_variable($_XDOCTX,'TOTLINES') div $nlpp)) ?> --calculate total number of pages based on number of records per page calculation
<!--?xdoxslt:set_variable ($_XDOCTX,'skip',0)?>
skip is used to handle the special scenario mentioned above. To prevent footer from coming across pages, move footer on next page along with one last record.
<!--?xdoxslt:set_variable($_XDOCTX,'ilast',70)?>
-- ilast is used to decide on number of spaces that should be displayed to display footer at bottom of page. ilast is number of records that can be displayed on a page with footer coming on that page.
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'nlast') = 0?>
<!--?xdoxslt:set_variable($_XDOCTX,'nlast',$nlpp)?>
<?end if?>
If number of records for last page is more than what last page can accommodate along with footer then we need to page break on last record.
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'nlast') >= xdoxslt:get_variable($_XDOCTX,'ilast')?>
<!--?xdoxslt:set_variable($_XDOCTX,'skip',1)?
<?end if?>
Looping through records
<!--?xdoxslt:set_variable($_XDOCTX,'i',xdoxslt:get_variable($_XDOCTX,'i')+1)?>
for special condition give page break just after second last record
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'tpage') = xdoxslt:get_variable($_XDOCTX,'page')
and xdoxslt:get_variable($_XDOCTX,'skip') =1
and xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'skip_at')?>
<xsl:attribute name="break-after">page
<?end if?>
--give page break after fixed number of lines per page
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'nlppv') +1 ?>
<xsl:attribute name="break-before">page
<!--?xdoxslt:set_variable($_XDOCTX,'i',1)?>riable($_XDOCTX,'page')+1)?>
<?end if?>
--spaces to display footer at bottom of page
<!--?if:xdoxslt:get_variable($_XDOCTX,’i’)< (xdoxslt:get_variable($_XDOCTX,’ilast’) - 1)?>
<!--?for-each:xdoxslt:foreach_number($_XDOCTX,1,xdoxslt:get_variable($_XDOCTX,'ilast') -xdoxslt:get_variable($_XDOCTX,'CR'),1)?>
<?end for-each?>
<?end if?>
* Display fixed number of records per page.
* On each page, display header
* Display footer on last page
* In case if footer is spanning across pages, move one record(last record) to next page and display footer at bottom of the page.
Fig 3. Special condition where footer spans across pages
Solution
Download complete template code
(open it and save it as rtf)
Download sample data
XML Data is of form
<ROOT>
<A>
<B1>lineB11</B1>
<B2>lineB12</B2>
<B3>lineB13</B3>
<B4>lineB14</B4>
</A>
..
..
</ROOT>
Lets quickly freshen up our XML Publisher Reports knowledge
How to declare variables?
XSL variable declaration
<? variable : a ; number(1) ?>
XML Publisher variable declaration
<? xdoxslt:set_variable($_XDOCTX,'i',1) ?>
How to use conditional logic in template?
<?if@inlines: [condition] ?> [value] <? end if ?>
Example
<?if@inlines: $a = 1 ?> Text <?end if?>
@Inline is used to print text on the same line, else its displayed on next line
How to use Looping constructs?
Looping for particular XML tag
for-each:current_group()
Looping n number of times<? for-each@inlines : xdoxslt:foreach_number ( $_XDOCTX,1,3,1) ?>This is an Example
<?end for-each?>
<?end for-each?>
"This is and Example" text will be printed 3 times in same line(notice @inline).
Parameters for foreach_number function are same like C programming for loop - initial value, end value and increment value
How to use Page Breaks?Below tags work only in Word form field. Other declarations can be entered like normal text, but this tags should be put in Word Form field tag.
<xsl:attribute name="break-after">page
<xsl:attribute name="break-before">page
Use this inside inline IF condition to give appropriate page breaks.
Now, Lets solve our problem.
1. Decide Number of lines per page : There is no formula that works for all scenarios. Number of lines that need to be displayed per page has to be decided based on
header size,
font size and
other factors.
Create a simple for-each loop in table to find out how many rows a page can accommodate and assign that value to the variable nlpp.
Lets say after the header which I have decided(refer Fig1) a page can accommodate 46 records. Declare number of lines per page in a a variable nlpp
<?variable:nlpp;number(46)?>
2. Calculate total number of lines : Total number of lines coming in data can be calculated by using count() function on particular node. Assign that value to variable TOTLINES
Consider that records are coming inside A node(refer to sample data above), like for 4 records there will be 4 A nodes present in data.
<?xdoxslt:set_variable ($_XDOCTX,'TOTLINES',count(//A))?>
this will count number of A tags coming in data, and assign that value to TOTLINES variable.
3. Page Break after every nth row : After every 46th record we want to give a page break. We decided number of records that we want per page and based on that we have to insert page breaks.
Using for-each:tag, loop through all the records
<?for-each:A?> <?B1?> <end for-each>
To keep track of count of records, we will increment variable i value using following loop
<?for-each:A?>
<?xdoxslt:set_variable($_XDOCTX,'i',xdoxslt:get_variable($_XDOCTX,'i')+1)?>
<?B1?>
<?end for-each?>
It gets the current value of i using get variable, adds 1 to that and sets new value of i.
After each nlppv(same as variable nlpp with value 46) number of records we want page break.
Check value of counter variable. When 47the record is reached give page break using xsl break-before and reset the counter variable value to 1.
<?if@inlines : xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'nlppv') + 1 ?>
<?xsl:attribute name="break-before"> page </xsl:attribute>
<?xdoxslt:set_variable($_XDOCTX,'i',1)?>
<?end if ?>
Now we have code in place to display each record column value and code to make sure that after every nth page a page break is inserted.
Just add Footer after the loop condition and when all records are processed, a footer will be displayed after it. But we need to display footer section at bottom of the page, so we need to add spaces based on some logic.
Decide Number of Blank Lines to add to display footer at bottom of the page.
The same way we decided value of variable nlpp in step 1, we need to run some test and check how many records a page can accommodate along with footer section().
<!--?xdoxslt:set_variable($_XDOCTX,'ilast',70)?>
If number of records on the page(value of variable i after loop is complete) is less that the total number of records that the last page can accommodate along with footer section(ilast value), we need to insert blank lines.
Following code will display blank lines to make sure footer appears at bottom of the page.
<?if:xdoxslt:get_variable($_XDOCTX,’i’)
< (xdoxslt:get_variable($_XDOCTX,’ilast’) - 1)?>
<?for-each:xdoxslt:foreach_number($_XDOCTX,1,xdoxslt:get_variable($_XDOCTX,'ilast') - xdoxslt:get_variable($_XDOCTX,'i'),1)?>
4. Special Scenario that need to be handled
Footer coming across pages: This scenario is for last page alone. We need to decide the number of records that can come in single page along with footer, without footer breaking across page.
Complete Code Explanation
Variable Declarations
<?variable:nlpp;number(46)?> -- number of lines that should be displayed per page before page break
<!--?xdoxslt:set_variable($_XDOCTX, 'page', 1)?> -- keeps track of page numbers
<!--?xdoxslt:set_variable($_XDOCTX, 'i', 0)?> --- variable used for looping through all records
<!--?xdoxslt:set_variable ($_XDOCTX,'nlast', (xdoxslt:get_variable($_XDOCTX,'TOTLINES') mod $nlpp)) ?> --calculate number of lines for last page
<!--?xdoxslt:set_variable($_XDOCTX, 'nlppv', $nlpp)?> --xsl variable nlpp declared above just for convenience of using short variable name
<!--?xdoxslt:set_variable ($_XDOCTX,'tpage', ceiling (xdoxslt:get_variable($_XDOCTX,'TOTLINES') div $nlpp)) ?> --calculate total number of pages based on number of records per page calculation
<!--?xdoxslt:set_variable ($_XDOCTX,'skip',0)?>
skip is used to handle the special scenario mentioned above. To prevent footer from coming across pages, move footer on next page along with one last record.
<!--?xdoxslt:set_variable($_XDOCTX,'ilast',70)?>
-- ilast is used to decide on number of spaces that should be displayed to display footer at bottom of page. ilast is number of records that can be displayed on a page with footer coming on that page.
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'nlast') = 0?>
<!--?xdoxslt:set_variable($_XDOCTX,'nlast',$nlpp)?>
<?end if?>
If number of records for last page is more than what last page can accommodate along with footer then we need to page break on last record.
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'nlast') >= xdoxslt:get_variable($_XDOCTX,'ilast')?>
<!--?xdoxslt:set_variable($_XDOCTX,'skip',1)?
<?end if?>
Looping through records
<!--?xdoxslt:set_variable($_XDOCTX,'i',xdoxslt:get_variable($_XDOCTX,'i')+1)?>
for special condition give page break just after second last record
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'tpage') = xdoxslt:get_variable($_XDOCTX,'page')
and xdoxslt:get_variable($_XDOCTX,'skip') =1
and xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'skip_at')?>
<xsl:attribute name="break-after">page
<?end if?>
--give page break after fixed number of lines per page
<!--?if@inlines:xdoxslt:get_variable($_XDOCTX,'i') = xdoxslt:get_variable($_XDOCTX,'nlppv') +1 ?>
<xsl:attribute name="break-before">page
<!--?xdoxslt:set_variable($_XDOCTX,'i',1)?>riable($_XDOCTX,'page')+1)?>
<?end if?>
--spaces to display footer at bottom of page
<!--?if:xdoxslt:get_variable($_XDOCTX,’i’)< (xdoxslt:get_variable($_XDOCTX,’ilast’) - 1)?>
<!--?for-each:xdoxslt:foreach_number($_XDOCTX,1,xdoxslt:get_variable($_XDOCTX,'ilast') -xdoxslt:get_variable($_XDOCTX,'CR'),1)?>
<?end for-each?>
<?end if?>
Wednesday, March 27, 2013
Signal 11 Error in Oracle Report
Unhandled Exceptions in Oracle report results in generic signal 11 error, most of the time.
Identifying the cause
Run the report in Oracle report builder with correct input parameter values.
Navigation : File->Generate to File->XML
If report errors with signal 11 in oracle apps, then running the report in report builder will throw exception with meaningful error message.
Reason
Identifying the cause
Run the report in Oracle report builder with correct input parameter values.
Navigation : File->Generate to File->XML
If report errors with signal 11 in oracle apps, then running the report in report builder will throw exception with meaningful error message.
Reason
- There is no provision for handling exceptions in main query block in Oracle report, so if main block query has some issue, it will result in signal 11 error or some warning, without showing meaningful error message. Mostly, the reason main query block fails is because of :
exact fetch returns more than one requested number of rows : select sub-query in main query block returning multiple rows or user defined function throwing exception.
numeric or value error : to_number function on alphanumeric column or joining two different data type columns.
- Unhandled exceptions in report triggers
validation trigger or after parameter form trigger or any other trigger having incorrect select queries or variable assignments which are not handled in exception block.
Subscribe to:
Posts (Atom)