Creating INSTEAD OF triggers on views (to define alternate INSERT, UPDATE, and DELETE logic on the underlying data) is a great way to simplify application...
Mark C. Stock
mcstock@...
Aug 1, 2002 6:29 pm
243
I just ran into something odd, I'm hoping someone has seen this before. We have one 8.1.7 install running on OpenVMS Alpha, and when I tried to connect using...
Hi, guys. Have a question about use of nested tables: I am dealing with a nested table (I simplified it for this purpose): CREATE TABLE boris_main_tab ( ...
I ran into a similar problem on OpenVMS. To get around it I just used internal. Thanks, Vidya...
Vidya Balasubramanian
vidya3200@...
Aug 5, 2002 5:07 pm
246
Did you look in V$PWFILE_USERS? The grants don't show in DBA_ROLE_PRIVS. Also, they cannot be granted from dba_studio or OEM. You will have to use svrmgrl or...
Blizard, Robert
robert.blizard@...
Aug 5, 2002 5:24 pm
247
I haven't worked with this much, but can't you use "WHERE m.children IS NOT NULL"?...
John Flack
johnf@...
Aug 5, 2002 8:35 pm
248
You have to use "internal" to grant SYSDBA and SYSOPER to other users. Ed Girard Applied Solutions, Inc....
Edward Girard
Edward_Girard@...
Aug 8, 2002 2:27 am
249
A couple of things to check. I'm wondering if the OpenVMS account used to install the Oracle software had all the appropriate privs and rights identifiers. On...
Grant Dixon
gdixon@...
Aug 8, 2002 2:31 am
250
Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production SQL> SELECT * FROM V$PWFILE_USERS; no rows selected SQL> Gives you a warm fuzzy...
I'm working on a project to convert a terabyte Sybase DB to Oracle 9i. Existing apps written for the Sybase database have been rewritten for Oracle and are...
Chip Paradise
ir001225@...
Aug 12, 2002 1:16 pm
253
Can Oracle Reports 6i use user-created functions and procedures? If so, how? If not, why not?!?!?!...
Hello, Does anyone know how to package Oracle Forms and make it into an executable? Any help will be appreciated. Phillip...
Phillip Small
psmall57@...
Aug 20, 2002 1:32 pm
255
Hello everyone. I have a function that combines several rows of information for a particular column into one record to be returned to an SQL statement. Table:...
Dear All, i installed oracle9i relase 2 on redhat linux 7.2. the installation completed successfully. when i try to run the sqlplus i recived the follwing ...
ibrahim al taher
ibrtaher@...
Aug 20, 2002 4:53 pm
257
Yes Oracle Reports can use user- defined functions and procedures.... In fact Reports 2.5 supported this feature....I 'wd be surprised if 6i didn't!! How to...
suresh.dharmapuri@...
Aug 22, 2002 2:42 pm
258
user-created functions (and procedures) stored in the database can be called in PL/SQL code and SQL code in any environment in Reports6i, this means that the...
Mark C. Stock
mcstock@...
Aug 22, 2002 2:43 pm
259
Does anyone have any experience converting an Oracle Forms application into an installable product (.exe) on client machines using Install Shield? If there is...
Phillip Small
psmall57@...
Aug 28, 2002 4:29 pm
260
According to Oracle, it can't be done. You must first install the Oracle network client and Forms runtime engine using the Oracle Installer, and then install...
John Flack
johnf@...
Aug 29, 2002 2:10 pm
262
Are there any Virginia state agencies who have experience implementing Self-Service for 11i HR or Financials ?...
Hello Carol, I am an independent Oracle HRMS Functional Consultant and just rolled off the implementation at UVa. We did Employee SS and Recruitment SS. They...
B S
oracle_hrms@...
Sep 5, 2002 5:41 pm
265
Folks, I have a tuning script that creates a spool file that is very lengthy. I would like to be able to add page numbers into the spool file, from the ...
bbuker@...
Sep 9, 2002 5:25 pm
266
Hope this helps .. TTITLE LEFT 'Page: ' FORMAT 999 SQL.PNO SKIP 1 - ******************************************************************************* VAIBHAV H....
Vaibhav Dani
vdani@...
Sep 10, 2002 1:40 pm
267
Bill, You can use the SQL.PNO field to place a page number in the header or footer of your page via TTITLE or BTITLE. Check in the Oracle SQLPlus manual for ...
Blizard, Robert
robert.blizard@...
Sep 10, 2002 1:41 pm
268
Thank you everyone for your responses. I ended up opening a TAR for this. It appears that the docs for OpenVMS are a little on the...incomplete side. I ended...
John Eisenschmidt
jeisensc@...
Sep 10, 2002 3:02 pm
269
Hi, I need to load flat files to database using SQL*Loader. For each file, I need to assign a transaction ID, and set it to every record in the file. For...
erica_he@...
Sep 15, 2002 2:26 pm
270
+ Interjection by listserv moderator: + Several helpful replies to this posting, below… From: "Mano Devamanoharan" <devamanp@...> Hi Erica: Try this....
Under Oracle Version 7.3.4, when I run a SQL*Plus query under Windows I get a pop-up window like the one below, which allows me to click on "Cancel" to have...
David Pohlig
david_pohlig@...
Sep 18, 2002 11:30 am
272
TO: vouglist@yahoogroups.com FROM: Virginia Oracle User's Group <vouglist@...> SUBJECT: RE: (VOUG) A new question + Interjection by listserv moderator: +...
David Pohlig
david_pohlig@...
Sep 18, 2002 11:00 pm
273
Just a quick question to see if this can be done or not. Can the refresh rate (default setting of 700) be adjusted for 8i? I am using 3rd party software to...
I have an image stored as a blob in the database. Can anybody describe how to get this image from the database as a .tif file using Oracle packages? Regards...
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.
