Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. henryz

    Using views inside the User Defined Function

    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.
  2. henryz

    Using views inside the User Defined Function

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

    Convert a MS-SQL function to Oracle

    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...
  4. henryz

    Using views inside the User Defined Function

    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...
  5. henryz

    How to count row numbers

    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.
  6. henryz

    How to count row numbers

    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...
  7. henryz

    LDAP Binding User Privileges

    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
  8. henryz

    How to check the JVM bits ?

    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
  9. henryz

    Advise on an installation failure

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

    How to check the JVM bits ?

    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?
  11. henryz

    How to check the JVM bits ?

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

    How to check the JVM bits ?

    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
  13. henryz

    Advise on an installation failure

    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
  14. henryz

    Advise on an installation failure

    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...
  15. henryz

    Tablespace for new Oracle user

    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
  16. henryz

    substitute the <CR><LF> with the string '<BR>' in Clob data co

    Mufasa, Thanks for your cheering comments. Regards, Henry
  17. henryz

    substitute the <CR><LF> with the string '<BR>' in Clob data co

    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
  18. henryz

    substitute the &lt;CR&gt;&lt;LF&gt; with the string '&lt;BR&gt;' in Clob data co

    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...
  19. henryz

    How to slice the result set by row number in SQL 7.0

    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
  20. henryz

    find level for every node in tree structure

    ...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...

Part and Inventory Search

Back
Top