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!

Search results for query: *

  1. BilliaUK

    Partitioned Indexes

    Niall "No DDL except the dropping and adding of partitions" ? Well then that IS DDL. You MUST use local partitioned indexes else you will be spending a considerable amount of time rebuilding indexes every day/week/month (partition add and drop frequency). Even in 9i, when you get the...
  2. BilliaUK

    system commands from PL/SQL

    This is VERY commonly asked question. Search on asktom.oracle.com for "OS commands from PLSQL" and you should see a VERY long thread with some code to use (I use it, it works) and all the ins and outs and caveats and pitfalls... Regards Adrian
  3. BilliaUK

    Partitioned Indexes

    Until 9i (when you can automatically rebuild global partitioned indexes following DDL on the parent partitioned table), I would strongly, no read, STRONGLY, advise you to use local partitioned indexes, UNLESS you are never going to either add,drop,merge,split partitions. If you do, you will...
  4. BilliaUK

    Return values pt. 2

    TyzA As long as you are happy using ref cursors (to pass back to JAVA) and creating SQL nested table types on the database, then this is simple. I don't use JAVA clients, so will show you a very simple demo - you can adapt it to your needs... -- -- Create SQL types... -- create type...
  5. BilliaUK

    Object Name size question

    Kris It is "accepted" good practice to anchor your variables to their underlying data sources in PL/SQL. I have been on the receiving end of supporting someone's particularly obfuscated code whereby a sequence had increased to allow up to nine didgits where the variable buried away in...
  6. BilliaUK

    TO_Date Problems...

    Does anyone want to comment on how this statement is not using bind variables so any chances of the app being developed scaling up are seriously jeopardised? This is SO common in VB apps... Regards Adrian
  7. BilliaUK

    Object Name size question

    Kris Re: not seeing a problem... Say I have a table MY_TABLES that stores some information from USER_TABLES (I have seen a site that stores its own dictionary data - crazy). OK, so MY_TABLES.TABLE_NAME is VARCHAR2(30) of course. Now, I have a dodgy piece of PL/SQL that populates MY_TABLES...
  8. BilliaUK

    Object Name size question

    Java objects can have up to 128 characters but I cannot imagine Oracle extending all other object names beyond 30. Imagine the backwards-compatability issues...potentially horrendous. I can't see it myself... Regards Adrian
  9. BilliaUK

    Java Stored Procedure to read a file

    Maybe you don't have execute privileges on DBMS_JAVA.GRANT_PERMISSION. If you did, you would need to:- BEGIN DBMS_JAVA.GRANT_PERMISSION('your_schemaname', 'java.io.FilePermission', 'your_path_and_file'...
  10. BilliaUK

    Table Name Variable with cursor

    Peter You need dynamic SQL for object references. I follow a rule of thumb - use DBMS_SQL for anything where you will need to execute many times as this parses once, executes many times. Use Native Dynamic SQL for anything where you will not execute many times (e.g. DDL, small number of row...
  11. BilliaUK

    Hi there i an trying to load data

    You don't need to include a SELECT statement to use the function. Syntax is ... APPEND INTO TABLE etc... ( COL_NAME "package.function" ) As an aside, this looks like you are getting a sequence to me. How about using a SQL*Loader sequence and save all that coding? If you load in...

Part and Inventory Search

Back
Top