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...
Good Morning Mark, I want to thank you for your time and effort. Unfortunately our environments are always adding tables. So this would be unwieldly to say the...
Prescribed@...
May 9, 2005 7:27 pm
724
Hi Mark, I did some reading in general and specifically on the execute immediate. It said for multiple rows I had to use the OPEN FOR and FETCH INTO format....
Prescribed@...
May 9, 2005 7:28 pm
725
Hi, I am using Compiere 2.5.1f. I have installed it in my PC(Server). Now I am trying to work from another PC(Client). I am using webstart to run the...
If you are adding new tables that often, I'm wondering about your database design - maybe you should be adding rows not tables, and maybe you need to look at...
How are you adding the recordd? Via the same tool on the both the client and the server? You'll need to provide the SQL statement if possible. ORA-01733 says...
Mark C. Stock
mcstock@...
May 11, 2005 5:40 pm
728
Ethangakannan, Hi. Can you answer a few questions. I assume you are running all the code on the server and logged in as the same person each time. There was a...
Allen Shepard
ashepard@...
May 11, 2005 5:41 pm
729
Try OTN (Oracle technology Network) site. Mano ... From: Gate.G.VOUGlist@yahoogroups.com Sent: Friday, May 06, 2005 6:41 AM To: diptimanmail@...;...
Devamanoharan, Mano
devamanp@...
May 11, 2005 5:41 pm
730
What kind of help do you need? We are using STATSPACK, and we are generating reports without any problems. ... From: VOUGlist@yahoogroups.com To:...
Earl, Ladonna
learl@...
May 12, 2005 4:14 pm
731
Hi, Thanks for your input. Today I finally learned how to write those embedded statements with a little help from other dba's and actually got some output ...
Prescribed@...
May 12, 2005 4:14 pm
732
Hi, What kind of trigger would I use in Forms to create a new record if one field is updated? I am trying to update a form that will create a new record if...
Phillip
psmall57@...
May 12, 2005 4:16 pm
733
Hi John, Thanks for your help. The information you gave me enabled me to get my program running without errors using a very small subset of the database. Now...
Prescribed@...
May 13, 2005 12:26 pm
734
To my way of thinking, the first question you should ask is "should this be done by Forms or by the database". In other words, is this a business rule that...
VOUG Membership - Thank you to everyone who takes the time to read through and reply to group email posts. The answers you've given have helped many folks -...
We are currently using Oracle Forms 10g. I made forms and a toolbar, upon deploying it in the web the toolbar disappears everytime I clicked the back button in...
Using a Windows XP platform, I loaded Oracle on the laptop. When I checked the services in the management console, I noticed it hadn't started. WHen I went to...
How can I get a job using Oracle if everyone requires 2 years of experience? I have over 15 years of PC database application development using the xBase...
First, make sure that you are prepared: Learn SQL, and especially for an xBase programmer, learn how true relational databases differ from quasi relational...
Get the personal version of ORACLE 9i or 10g. Install the software, create your own database, install OEM, configure OEM, figure out how the network piece...
clewis@...
May 27, 2005 1:05 pm
742
David, Contracting, programming and investing in yourself worked for me. Back in '85 while taking Computer Science at ODU they had several courses in Database....
Allen Shepard
ashepard@...
May 27, 2005 2:35 pm
743
You could assemble a system relatively easily for "learning" purposes. Virtually everything below came off internet auction sites Sun Ultra 10 with Solaris 7...
Dr Robert Young
rcyoung@...
Jun 1, 2005 12:02 am
744
HI ALL, RECENTLY I JOINED THIS GROUP.I AM WORKING ON DISCOVERER.I WANT TO KNOW HOW CAN A LEXICAL PARAMETER CAN BE INCORPORATED IN DISCOVERER. COZ IN MOST OF...
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.
