Recent content by henryz

Sorry BJ, I double checked again, and yes, you are right, this is related to the naming convention. I change the parameter name to something else as you suggested, and it worked. Thanks a lot.

Thanks. Tried the above naming convention, it did not make difference.

Hi, I have a function in MS-SQL, but have difficulity to convert it into Oracle, can someone help please? Here is the Function: --===== Create a function to concatenate orders by customer CREATE FUNCTION dbo.ConcatOrderNum (@pCustomerID AS INT) RETURNS VARCHAR(8000) AS BEGIN DECLARE...

Hi, Does anybody have experience using views inside a function in Oracle? Technically it should be fine. but I had problem with the following simple view: CREATE OR REPLACE FUNCTION MetaData(Id NUMBER) RETURN VARCHAR2 AS infotypes VARCHAR2(10000); infovalue VARCHAR2(255); CURSOR...

Thanks Mufasa. This solution looks pretty good, but our database is reasonable large, with over a million records. Tried this on our database, it just timed out without returning any results. Appreciate your help anyway.

Hi, For example I have a simple table called Session like this: PersonID SessionNum ========== ============= 101 105 101 21 102 33 102 46 102 57 103 69 . . . . The SessionNum are unique, but in a random...

Hi, I try to establish a connection from a client to a LDAP server. I use a normal user as the binding user, but I get this error message "Failed to bind the LDAP server: Invalid Credentials". Are there any user right requirement for the binding user? Thanks, Henry

Hi SamBones, The server I use is an Itanium (64bits) processor, so it's definitely in a 64 bits world. Tried the command on my server box: getconf WORD_BIT Interesting it returned with 32, which I think it's wrong. Maybe there is a bug there. Thanks, Henry

Thanks Guys, looks like this is an issue related to the version of JVM.

Thanks SamBones, your command is checking the Linux kernel bits, not sure if it checks the JVM bits. Maybe it's easy to have a scenario, say two versions of JVM installed on a Linux server, one is 32 bits JVM, another is 64bits JVM. How can you differentiate them?

That's what you guess, can you check somewhere, do you know any commands to confirm this?

Hi, I have a JVM installed on a Linux box, can someone tell, how to find if this is a 32 or 64 bits of JVM? How to check it? Where can I find/and download 64 bits 1.3.1 JRE? Thanks, Henry

Sorry, forget to mention the spec for this box: Red Hat Enterprise Linux AS release 3 (Taroon Update 3) Kernel 2.4.21-20.EL on an ia64

Hi, I try to install an application on a new Linux Box, but end up with this errors, and installation can't complete. " Launching installer... /tmp/install.dir.9819/Linux/resource/jre/bin/../bin/realpath: line 22: /tmp/install.dir.9819/Linux/r esource/jre/bin/../bin/ia64/realpath: No such file...

Hi, Here is a question. When I create a new user in Oracle database, I normally assign "SYSAUX" as its default Tablespace, and "TEMP" as its Temporary Tablespace. Is it a good practice? Any performance effect? are there any ground rules when assigning Tablespaces to new users? Thanks, Henry