I am not trying to do an update of one record that lies in many tables. However, when I write a simple select to view the file before doing the update, I get...
P
psmall57@...
Apr 12, 2005 9:41 pm
693
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: Brett Ogletree <bretto97@...> Are you sure you are...
I've got an associate in Phili looking for feedback from anyone who's using 10g in a data warehousing environment before he migrates from 9i. Anyone got any...
Mark C. Stock
mcstock@...
Apr 15, 2005 7:30 pm
695
I am getting a couple of errors that really do not tell me the actual error. ora-01733 : virtual column not allowed here Also a statement ignored error but...
P
psmall57@...
Apr 15, 2005 7:31 pm
696
Hello, I am writing a stored procedure that will update 38 some odd tables. However, my question is are substrings allowed in update statements in a...
P
psmall57@...
Apr 15, 2005 7:32 pm
697
I am working on a Oracle 10G database on Sun platform and am trying to write a procedure that will have 2 parameters to update tables but I want to substring...
P
psmall57@...
Apr 18, 2005 2:08 pm
698
Is this an "update where current of"? If so, is there an expression in the SELECT statement? That might cause your problem. It is possible that you are...
Hi, Saw your problem maybe this generic parsestring parser may help you. Go to this web site: http://www.quest-pipelines.com/pipelines/plsql/archives.htm Click...
Prescribed@...
Apr 20, 2005 7:25 pm
700
Hi John, Thanks for getting back to me. Today we resolved the problem in the office. It was lack of a role on the procedure that was causing the error. Our ...
Prescribed@...
Apr 20, 2005 7:29 pm
701
+ Interjection by listserv moderator: + If you would like to respond to this message, please send your + reply directly to the author at lc7957@... (do...
Why do people hate Oracle? By Philip Howard, Bloor Research 20th April 2005 Comment I have on my bookshelf a book called "Why do people hate America?" by...
+ Interjection by listserv moderator: + Good commentary on this earlier posting. As Oracle professionals, + it's important that we recognize both the...
Allen Shepard
ashepard@...
Apr 22, 2005 5:56 pm
704
Hi, I want to use prompts and questions in a stored procedure? Is that allowed? Ex. Do you want to add another record? What is the user name? If the user...
Phillip
psmall57@...
Apr 27, 2005 5:47 pm
705
Hi Everyone, I am working on a script at work that involves passing a cursor result into a record. After that that record gets further massaged. My problem is...
Prescribed@...
Apr 27, 2005 5:48 pm
706
from http://www.peoplesoft-planet.com Oracle’s spending spree hasn’t finished yet, with the company looking to make more billion dollar-plus deals, its...
Hi, I need some help and cannot figure out why this query won't work. I am using oracle 9.2. I need to retrieve information, a count, from OLS that is located...
Prescribed@...
Apr 27, 2005 5:50 pm
708
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... =================================================================== ...
This is a frequently asked question. Unfortunately, there is no good way to have a PL/SQL procedure in SQL*Plus interact with the user, especially not in a...
When you say "INSERT INTO own_rec_type" you are implying that own_rec_type is a table. There is no table by that name, so you get the error. own_rec_type is...
No, that's not possible -- a stored procedure executes inside the database, there is no user-interaction. SQL*Plus is really not designed for interactive...
Mark C. Stock
mcstock@...
Apr 29, 2005 1:25 pm
712
This solution is not plsql but pure sql but it may help you create a file called userInteraction.sql with the following code ... set pages 1000 set feed on ...
Does anyone have any experience with Oracle Financial Data Manager 4.5 (OFSA 4.5). I need help with the upgrade from OFSA 4.0 to 4.5. In particular, I need...
Eng, Robert
reng@...
Apr 29, 2005 7:14 pm
714
Hi John, So what you are saying then is that a table has to be created with this same name before the records can be inserted using the record own_rec_type....
Prescribed@...
Apr 29, 2005 7:15 pm
715
Hi There are several issues with this code such as defining record once from cursor and once from table%rowtype. Even if identical will not work. Also you...
Ibrahim Bakhit
i_bakhit@...
May 2, 2005 8:02 pm
716
As you have it defined, own_rec_type is not a table, it is a record, containing the same fields as the columns in the table named dba_object_tables. As I said...
Good Morning Ibrahim, Thanks for getting back to me. It appears from your script that my thoughts were right. That the record is declared by the engine...
Prescribed@...
May 4, 2005 12:57 pm
718
Hi all, I am new to this board, just join today. I have question about Oracle license. I have 2 box of 4 cpu IBM P5 machine totaling 8 cpu. I hard...
Al, You may want to spend a little time reading the PL/SQL manual, and any of Steve Feuerstein's books and articles -- you seem to be drawing a lot of wrong...
Mark C. Stock
mcstock@...
May 5, 2005 5:41 pm
720
Good Morning John, Thanks for the advice. After reading again the same subject matter I have come to that same conclusion. Due to lack of experience my...
Prescribed@...
May 5, 2005 5:42 pm
721
Mark - Your solution to the count script looks good to me. On the other hand, it seems to me that maybe what is needed is not PL/SQL at all, but a VIEW. The...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
