Do all DBMSs have a flat address space for stored procs? The guy above who had 3000 procs in the database - how can you manage such a load without packages or libraries or directories to organise them?
To address the issues of vendor tie-in, what if the stored procedures are written in a common language, such as Java? I know that Sybase and Oracle both allow Java stored procedures instead of Transact SQL and PL-SQL. The J-Procs are basically JDBC code, and would be much more likely to be vendor-neutral. Is anyone in the world using Java stored procedures in these two DBMSs?
Slashdot Mirror
"Will incent"? Incent? From the French perhaps.
Do all DBMSs have a flat address space for stored procs? The guy above who had 3000 procs in the database - how can you manage such a load without packages or libraries or directories to organise them?
To address the issues of vendor tie-in, what if the stored procedures are written in a common language, such as Java? I know that Sybase and Oracle both allow Java stored procedures instead of Transact SQL and PL-SQL. The J-Procs are basically JDBC code, and would be much more likely to be vendor-neutral. Is anyone in the world using Java stored procedures in these two DBMSs?