Lowyat.NET: Latest topics by klenny

Oracle behaving weirdly

klenny — Fri, 31 May 2013 00:11:57 +0800

I was creating a function in oracle then suddenly this happen
so this is what basically function look like

sorry but cannot remember syntax

CODE

create or replace function foo (input_string nvarchar2, input_date)
return nvarchar2 is
var1 nvarchar2(100);
var2 nvarchar2(100);
BEGIN

-- PART I
-- take input to get var 1

-- PART II
-- take var1 to get var2

return var2;

END;
/

So I tried the function with parameters that I know will return value but I get null as result and after debugging I found out that
at PART II that var1 suddenly become null

CODE

create or replace function foo (input_string nvarchar2, input_date)
return nvarchar2 is
var1 nvarchar2(100);
var2 nvarchar2(100);
BEGIN

-- PART I
-- take input to get var 1

return var1;

END;
/

-- THIS RETURNS CORRECT VALUE

Any idea why this happens? Btw problem solved by taking PART II to another function.

eUtama Sdn Bhd

klenny — Thu, 17 May 2012 16:48:52 +0800

Hi, anyone know anything about this company?
Working environment?
Benefits?

Going there for an interview

Romantic place buka puasa

klenny — Mon, 08 Aug 2011 14:14:12 +0800

Any recommendation?
Preferred less than 30 minutes drive from selayang since nk kena balik mandi dulu petang ni
Please post website if the restaurant got one

thank you

Ball End Stuck In Bridge

klenny — Fri, 02 Jan 2009 15:47:13 +0800

hi all
im doing my first string change
but the 3rd/b string ball end is stuck in the bridge
been poking at it for 3 hours but to no avail
any help is very much appreciated