ROWID PROBLEM
Title: RE: alter table rename error HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY
fetching long variable in PL/SQL
Hi all , I have a problem about fetching long variable in PL/SQL. I encountered with problem in following PL/SQL block. When I try to fetch long variable , I receive PL/SQL: numeric or value error ORA-06512. As I searched in metalink, it is releated to size of long variable. Probably it is greather than 32KB. I could not find a solution. Do you have any info or and advice that how I can fetch long variables greather than 32KB. May it can be divided into more than one variable but how. Thanks Arslan. DECLARE USER_TRIGGERS_COUNT NUMBER := 0; USER_TRIGGERS_COUNTER NUMBER := 0; CURSOR USER_TRIGGERS_CUR IS SELECT TRIGGER_NAME ,DESCRIPTION , trigger_BODY FROM USER_TRIGGERS where trigger_name = 'TRG_APPL_CONTRACTS_BIUD_R' ; USER_TRIGGERS_R USER_TRIGGERS_CUR%ROWTYPE; BEGIN select COUNT(*) INTO USER_TRIGGERS_COUNT from USER_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER'; OPEN USER_TRIGGERS_CUR; LOOP FETCH USER_TRIGGERS_CUR INTO l_TRIGGER_NAME ,l_DESCRIPTION ,l_BODY ; EXIT WHEN(USER_TRIGGERS_CUR%NOTFOUND ); NULL; END LOOP; CLOSE USER_TRIGGERS_CUR; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: fetching long variable in PL/SQL
convert to a lob and use a substr. That might fix the problem. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, January 25, 2004 10:24 AM Hi all , I have a problem about fetching long variable in PL/SQL. I encountered with problem in following PL/SQL block. When I try to fetch long variable , I receive PL/SQL: numeric or value error ORA-06512. As I searched in metalink, it is releated to size of long variable. Probably it is greather than 32KB. I could not find a solution. Do you have any info or and advice that how I can fetch long variables greather than 32KB. May it can be divided into more than one variable but how. Thanks Arslan. DECLARE USER_TRIGGERS_COUNT NUMBER := 0; USER_TRIGGERS_COUNTER NUMBER := 0; CURSOR USER_TRIGGERS_CUR IS SELECT TRIGGER_NAME ,DESCRIPTION , trigger_BODY FROM USER_TRIGGERS where trigger_name = 'TRG_APPL_CONTRACTS_BIUD_R' ; USER_TRIGGERS_R USER_TRIGGERS_CUR%ROWTYPE; BEGIN select COUNT(*) INTO USER_TRIGGERS_COUNT from USER_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER'; OPEN USER_TRIGGERS_CUR; LOOP FETCH USER_TRIGGERS_CUR INTO l_TRIGGER_NAME ,l_DESCRIPTION ,l_BODY ; EXIT WHEN(USER_TRIGGERS_CUR%NOTFOUND ); NULL; END LOOP; CLOSE USER_TRIGGERS_CUR; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ROWID PROBLEM
Title: RE: alter table rename error you need to read the documentation. Oracle is supposed to workt his way. otn.oracle.com start with the concepts document. Skip the stuff on java, xml, etc... read the first 10-12 chapters. - Original Message - From: Waleed Haggagy To: Multiple recipients of list ORACLE-L Sent: Sunday, January 25, 2004 10:19 AM Subject: ROWID PROBLEM HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY
Designer Installation Question
Hello: I'm reviewing the Oracle Descripter 9.0.2 installation instructions amd wondered is there anyway to just install Designer without all of the other programs(JDeveloper, Oracle Forms Developer, etc)? I was hoping to just use the DB Modeling functionality. Thanks In Advance, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: fetching long variable in PL/SQL
You have to use dbms_sql ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Sunday, January 25, 2004 10:44 AM To: Multiple recipients of list ORACLE-L convert to a lob and use a substr. That might fix the problem. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, January 25, 2004 10:24 AM Hi all , I have a problem about fetching long variable in PL/SQL. I encountered with problem in following PL/SQL block. When I try to fetch long variable , I receive PL/SQL: numeric or value error ORA-06512. As I searched in metalink, it is releated to size of long variable. Probably it is greather than 32KB. I could not find a solution. Do you have any info or and advice that how I can fetch long variables greather than 32KB. May it can be divided into more than one variable but how. Thanks Arslan. DECLARE USER_TRIGGERS_COUNT NUMBER := 0; USER_TRIGGERS_COUNTER NUMBER := 0; CURSOR USER_TRIGGERS_CUR IS SELECT TRIGGER_NAME ,DESCRIPTION , trigger_BODY FROM USER_TRIGGERS where trigger_name = 'TRG_APPL_CONTRACTS_BIUD_R' ; USER_TRIGGERS_R USER_TRIGGERS_CUR%ROWTYPE; BEGIN select COUNT(*) INTO USER_TRIGGERS_COUNT from USER_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER'; OPEN USER_TRIGGERS_CUR; LOOP FETCH USER_TRIGGERS_CUR INTO l_TRIGGER_NAME ,l_DESCRIPTION ,l_BODY ; EXIT WHEN(USER_TRIGGERS_CUR%NOTFOUND ); NULL; END LOOP; CLOSE USER_TRIGGERS_CUR; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ROWID PROBLEM
You need to understand that Oracle inserts data where space is available in a table, and dependent on previous DML in a table, that could be almost anywhere. If you want to see the data in timestamp order, then order it by that column. And please don't use ALL CAPS. It is difficult to read. Jared On Sun, 2004-01-25 at 07:19, Waleed Haggagy wrote: HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman expired vs obsolete
Hi! Expired backups are unusable since they were not found accessible during last crosscheck or were set to expired state manually. This means that these backups can't and won't be used for restore operation. Obsolete backups can be deleted since there are enough redundant backups according to current backup retention policy. If an obsolete backup is not manually deleted yet, it can be used for restore, unlike expired backups. Backup retention policy can be changed using rman's configure command. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 23, 2004 9:59 PM Hi, I'm getting a little confused between expired backups and obsolete backups. As I understand it, expired means the backups are no longer on disk. Obsolete means the backup is too old(?). Since I have a data ware house, I only have room on disk for 1 backup. Prior to running my weekly backup, do I issue a Delete Expired or Delete Obsolete, to remove last weeks backup that is currently on disk. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ROWID PROBLEM
Title: RE: alter table rename error Maybe the problem is with your capital letters?! Tanel. - Original Message - From: Waleed Haggagy To: Multiple recipients of list ORACLE-L Sent: Sunday, January 25, 2004 5:19 PM Subject: ROWID PROBLEM HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY
RE: ROWID PROBLEM
Title: RE: alter table rename error Yeah ... in 9i, rowid's in capital letters don't work correctly, they only work on Windows ... which is case insensitive. 8:) Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Sunday, January 25, 2004 5:55 PMTo: Multiple recipients of list ORACLE-LSubject: Re: ROWID PROBLEM Maybe the problem is with your capital letters?! Tanel. - Original Message - From: Waleed Haggagy To: Multiple recipients of list ORACLE-L Sent: Sunday, January 25, 2004 5:19 PM Subject: ROWID PROBLEM HI ALL.. I HAVE PROBLEM THE ROWID FIELD IS NOT SORTED IN MY DATABASE WITH THE INSERTION DATA.. I INSERT THE TIME WITH EVERY RECORD AND WHEN SELECT FROM THE TABLE WITH ORDER BY ROWID I GET RANDOM TIMES IN TIME FIELD !!! THAT HAPPEND WITH ME IN ONE TABLE ONLY WALEED HAGGAGY**This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
Re: Oracle vs Mysql
I have a book devoted to PostgresSQL at home. When I come home, I'll post the information. O'Reilly has Practical Postgresql, the full text of which is also available online: http://www.commandprompt.com/ppbook/ I know there are a couple of others floating around as well. But you're right, MySQL (sadly, IMO) has the mindshare. I'm not sure about sadly, this is very much a development model difference just like between linux and freebsd. Postgresql is (culturally and otherwise) an extension of the university project, mysql is a much more in the weeds do-over. Currently I'd point people looking for opensource databases postgres for complicated problems as it has a lot more of what one would expect to see in a database product, but if their needs are simple or they are looking for long term then i'd suggest mysql. Mysql has (like linux vs. *bsd) a much larger share of the developer mindset and that is the most important thing when it comes to opensource software. -- craig .-... . -.-. .-. . --- . ... ... .- --. . Craig I. Hagan hagan(at)cih.com Scientists have discovered that research causes cancer in rats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig I. Hagan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
** field names of a ref cursor
Hi, I am calling a Oracle stored procedure which has a ref cursor as a out param. I get the values. Is there a way for me to know the field names and type of the fields being passed in the ref cursor. Basically when the procedure sends back the ref cursor what information do I get apart from the data. Do I get any metadata (field names types etc). This is basically to write a calling program which I do not have to change when the ref curor /record changes in the stored procedure. Thanks in advance. Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!