Oracle Connect Newsletter – December 2009 Issue Oracle Connect Newsletter December 2009 Issue This month's issue focuses on the different aspects of Oracle e- Business Suite. http://www.iwarelogic.com/blog/oracle-connect-news-258 ... 28 Dec 2009 08:32
what book for 9i or 10g forms? I am doing maintenance on a 9i forms application that we are migrating to 10g. It mostly works without change, except for a FRM-92100 exception that did not occur under 9i. In order to debug this, I need to better understand how control flow actually works, e.g., the order in which the various code fragments ex... 28 Dec 2009 14:03
usage of calculated index with a synonym for the function Hi, in a large table OUR_TABLE we have a calculated index for a persons-name with a simple soundex function OUR_SOUNDEX in the same schema (OUR_SCHEMA) like the table, thats different to my "select"-schema (WORK_SCHEMA): .... from OUR_SCHEMA.OUR_TABLE d where OUR_SCHEMA.OUR_SOUNDEX(d.PERSON_NAME) = OUR_... 23 Dec 2009 10:49
Basic Tables in Oracle Financials Here are all the Imp tables used in oracle Financials http://www.ezdia.com/Basic_Tables_in_Oracle_Financials/Content.do?id=81 ... 14 Dec 2009 06:36
"Business Logic / Rules should never be in the database or stored procedures" On 13.12.2009 09:24, Thomas Kellerer wrote: * In my experience, those who argue for not having any business rules/logic in the database tend to be developers who are essentially lazy and refuse to learn anything about the database or its facilities. They just want to use it as a bit bucket and do ab... 13 Dec 2009 07:44
"Business Logic / Rules should never be in the database or storedprocedures" > * In my experience, those who argue for not having any business rules/logic in the database tend to be developers who are essentially lazy and refuse to learn anything about the database or its facilities. They just want to use it as a bit bucket and do absolutely everything in the application... 14 Dec 2009 16:34
PL SQL Error This one is kind of confusing. The max length of a VARCHAR2 is 4000. So, I call a stored procedure passing is a value that is 3278 characters long, basically text. I receive an error: SP2-0027: Input is too long (> 2499 characters) If I code that into a variable inside some code, same thing. Breaking it ... 12 Dec 2009 08:03
VARCHAR2 Length So, the max length of VARCHAR2 is 4000 bytes. So, in PL/SQL, if you need to declare a variable longer than 4000, what can you use? We need to declare a variable and continue to concatenate strings onto it and it becomes longer than 4000 bytes, so, we're SOL? Still looking for the answer on other sites. ... 10 Dec 2009 15:37
Pivot table Query - Need help in building correct logic Greetings, I have a table format as below sec value type X 100 T X 200 S Y 300 T Y 400 S Z 500 T Z 600 S I want to pivot the above to somethin as below sec T S ... 5 Dec 2009 08:31
The job of a relational DBMS Gene Wirchenko <genew(a)ocis.net> writes: On Tue, 01 Dec 2009 08:50:34 +1100, Ben Finney <bignose+hates-spam(a)benfinney.id.au> wrote: joel garry <joel-garry(a)home.com> writes: [snip] Can't a function be part of the DBMS? A non-relational function shouldn't be part of a relational DBMS... 8 Dec 2009 19:45 |