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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Thargy

  1. Thargy

    Is Tom Dead?

    Hi everyone. I (like many others) used to frequent "Ask Tom" for much useful insight and assistance with all things oracle. The site has hitherto been nigh on unbeatable for evidence-based clear answers to sometimes murky questions. However, Tom hasn't answered a question for over three months...
  2. Thargy

    Oracle and Tiff Images

    Diego, We have a similar problem in my place of work. It was originally decided (against my advice) to store files in the operating system, instead of the database. This was supposed to be both easier and quicker but has in the end, turned out to be a liability. When it comes to DR and/or...
  3. Thargy

    Variable in a package with pipelined function

    Crystal, I don't know anything about business objects universes, but since a function is a type of stored procedure, I don't understand the restriction. If you're receiving parameters in a stored procedure, then the universe must presumably be able to respond to the stored procedure - correct...
  4. Thargy

    Variable in a package with pipelined function

    crystal, I believe that your approach to this in not the best. Whilst it is possible to use dynamic table names in queries, it's often extremely hard to debug anything. Can you give an over view of what you're trying to achieve - an English language narrative of what you're trying to...
  5. Thargy

    Librarian wants to ban 5-time reading champ from contest

    er, um, impugn anyone? Regards T
  6. Thargy

    Using REPLACE on CLOB causes increase in CACHE_LOBS...

    Slice, When confronted with this sort of issue, I often try using SQL. PL/SQL is a great language, and I use it almost daily, but for sheer flat out speed, you just can't beat SQL. In the table in question have you considered creating a target column which is the replace of the source clob...
  7. Thargy

    How can we rename a sequence that another user owns?

    I suppose inspecting its parameters, dropping it and then recreating it with the new name and identical parameters is out of the question? Is it mandatory to rename, or will achieving the same effect as renaming suffice? Regards T
  8. Thargy

    Table or View does not exist

    Dave, Can you post create table statements and insert statements so I can try to reproduce your issue? If not, then I suggest a divide and conquer approach. The second query has no join conditions in the from clause, so I'm guessing you're getting lots of unexpected records returned. I...
  9. Thargy

    Table or View does not exist

    The most obvious one is to check that the user in question has select privilege on all the tables involved in the query. Regards T
  10. Thargy

    Detect SQL injection and Prevent SQL injection.

    but don't let it go unsaid that the obvious answer is to use a stored procedure interface - that guarantees that SQL injection will never occur. Failing that, use sql statements with bind variables. Cut it off at source, don't try to catch it once it's happened. Regards T
  11. Thargy

    Function with SDO_GEOMETRY

    Andy, In general, all code should be in a package. This enables encapsulation of the code, and improves security. It enables the declaration (in the package specification) of constants and variables with restricted scope. It also enables you to develop a library of associated functions and...
  12. Thargy

    Function with SDO_GEOMETRY

    Hi there. I've just read through your code which seems to be quite good, so I only have a couple of general items to mention. First of all, if this isn't in a package, create one and put it in there. Second, in the package specification you should declare some constants to make the code more...
  13. Thargy

    Want to create Store proc on my sql query buy i get error wrong number or types of arguments

    What are you trying to do with this stored procedure? It just runs a select statement. What is the error you are receiving? Regards T
  14. Thargy

    Table's ROWID as a PK/unique key

    Santa, the problem wasn't splitting a table or tables, it was splitting the entire database! I didn't split any table, I produced four separate databases with identical structures. Then the data from each functional part was moved out into its own database and worked on. At the end, four...
  15. Thargy

    Table's ROWID as a PK/unique key

    Trust you to pose a good question. The reason was that one database fulfilled four (in fact more) separate business functions. Due to bad design, there was no functional isolation in the database, and so I had to artificially create some, by splitting the data in to four sets. This enabled...
See more

Part and Inventory Search

Back
Top