Search results for query: *

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

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

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

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

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

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

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

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

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

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

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