Oracle
in [SQL]
|
ORA-06502: PL/SQL: numeric or value error: character string buffer too small Dear Gurus, I have written below function FUNCTION Get_Loc_Dtl ( No IN VARCHAR2, Date_Cond IN VARCHAR2 ) RETURN VARCHAR2 is l_Start_Date DATE; l_End_Date DATE; l_Location_Detail VARCHAR2(32767) := NULL; BEGIN l_Start_Date := TO_DATE(Date_Cond||' '||'00:00:00','DD-MON-YYYY HH24:MI:SS'); l_End_Date... 8 Jun 2010 12:33
Urgent Multiple Requirements Hi, Greetings!!!!! Here are urgent requirements. Please check the requirements and get to back me with up dated profiles as soon as possible. Requirement:1 Title: Java Server Side Engineers Location: San Mateo CA Need locals as there will be FTF interview. Duration:6months Description: Jav... 3 Jun 2010 12:15
SQL%ROWCOUNT includes counts from subqueries? I have an update statement that if run by itself updates 14 rows, but when I test the value of SQL%ROWCOUNT it's value is 28. I'm wondering if SQL%ROWCOUNT is counting both the rows found in a subquery as well as the rows updated by the subquery. Basically update tablex set (col1, col2, col3) = (se... 3 Jun 2010 21:14
reThink Migration � It�s Time for Change! "Anil Mahadev" <anil.mahadev(a)gmail.com> wrote in message news:cf6d51dd-ee78-460a-a812-1c2283ad262c(a)v12g2000prb.googlegroups.com... Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the �Village of Orrible� who want to break free from the baron�s t... 2 Jun 2010 20:54
Requirement:Data Analyst Hi, Greetings!!!!! Here is urgent requirement. Please check requirement and get to back me with up dated profiles as soon as possible. Title: Data Analysts/ Data Modeler Location: Gorton CT Duaration:4 months Description: 1. Strong Data Modeling skills clear understanding of normal form... 2 Jun 2010 15:21
reThink Migration – It’s Time for Change! Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the Village of Orrible who want to break free from the barons taxes and flee to the wonderful town of DB2, over on the other side of migration mountain. Watch it @ rethinkmigration.com and spread the word. ... 2 Jun 2010 13:07
Index strategy I now work at a shop where the developers over the years have added many (random) indexes on the database, and (still) having problems with performance. I see many sql-statements coming by that use suboptimal indexes, I think it would be a good idea to mass-review the sql and indexes, increasing the quality of the ... 12 Jun 2010 14:51
We are here for all your events! Attention! Need an excellent event management for your business and home we must do events on your behalf with attractive Fees! Contact us :-) Rtlx Groups 61 PNS Gold Mahal, South Avani Moola Street, Madurai - 625 001, Ph No. 0452-4230735, MBL 9597766651/52 Website: www.rtlxgroups.com Email ID: rtlxgro... 1 Jun 2010 04:18
snapshot too old error I am on Oracle 11.1.0.7 and HP UNIX 11.23i. I am doing an expdp and get following error expdp system/password directory=expdp_dir dumpfile=expdp.dmp logfile=texpdp.log schemas=PQMS PARALLEL=1 exclude=statistics compression=all ORA-31693: Table data object ""COMPLAINT_LTR_ORIG" failed to load/ unload and is being... 4 Jun 2010 08:05 |