Search results for query: *

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

Mufasa, Thanks for your cheering comments. Regards, Henry

Thanks Mufasa for your kind response. I am based in Sydney, Australia. Finally I manage to solve this problem by using this workaround: replace((dbms_lob.substr(clob, dbms_lob.getlength(clob),1)), chr(13)||chr(10), '<BR>') It does not look pretty, but it works. Cheers, Henry

Hi, I have a table in Oracle 8i, with a clob column. Now I want to execute a query like the following: REPLACE(<clob_column>, CHR(13)||CHR(11), '<BR>') But I receive an error complain with "Inconsistent datatype". Can anybody suggest a workaround for this please? We need this very urgent...

Hi, Is it possible to slice the result set by row number in SQL 7.0 ? I know in Oracle, there is a keyword called &quot;ROWNUM&quot; which can easily slice the result by specifying a fixed number of returned rows. How can we do this in SQL 7.0? Thanks Henry

...I.parentCode, I.itemName, I.ID, @lvl FROM Items AS I JOIN #Tree AS T ON I.childCode = T.parentCode AND T.lvl = @lvl - 1 END SELECT * FROM #Tree ORDER BY lvl desc After execute the code , the level for every node is 0 which is not what I want. Could you please have a look for my...