Home » Developer & Programmer » Forms » Please Suggest (Oracle 10g, Forms 6i, Windows)
Please Suggest [message #502981] Tue, 12 April 2011 01:39 Go to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
I create different database users like STORE, PAYROLL, GL , SYSADMIN, COMMON to contain objects accordingly then I create another user ABC and grant DBA privileges to all users.

After that I grant SELECT/INSERT/UPDATE/DELETE privileges on each and every objects of STORE/PAYROLL/GL/SYSADMIN/COMMON users to ABC then create synonyms of STORE/PAYROLL/GL/SYSADMIN/COMMON users objects into ABC.

Actually, I want to use single user of ABC to build/execute my application but I think I am doing something wrong because whenever I tried to compile my form, its showing this error.

Any help-full information/suggestion would be highly appreciated.
  • Attachment: Untitled.jpg
    (Size: 86.66KB, Downloaded 624 times)

Report message to a moderator

Re: Please Suggest [message #502993 is a reply to message #502981] Tue, 12 April 2011 03:14 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
ORA-0600 => oracle bug => contact oracle support.

Report message to a moderator

Re: Please Suggest [message #503012 is a reply to message #502993] Tue, 12 April 2011 04:39 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, it seems that you are running (actually, trying to run an unsupported combination.

Your luck might depend on exact versions of both products. Which versions do you use (meaning: specify decimals)? As far as I can tell, if you apply Forms 6i patch 18, you *might* be able to compile (and run) your forms against 10gR2 database. On the other hand, your reports might still not work properly.

So, how about upgrading forms to newer (10g) version?

Perhaps you should check My Oracle Support's notes in order to see what to do; anyway, you'll have to contact them because ... see what Cookiemonster said.

Report message to a moderator

Re: Please Suggest [message #503157 is a reply to message #503012] Wed, 13 April 2011 04:56 Go to previous messageGo to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
Thanks Littlefoot

Actually, I tried to install developer suite 10g at windows7 but I think it is not supported at windows7 therefore I am using forms6i. Please update me, if I am wrong and provide me some details, how to install at windows7?

I will be very gratefull to you for this kind favor you give, I want to use forms/reports 10g.

[Updated on: Wed, 13 April 2011 04:56]

Report message to a moderator

Re: Please Suggest [message #503158 is a reply to message #503157] Wed, 13 April 2011 05:10 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What I did was to install Virtualbox on my Windows 7 machine. I installed Windows XP on Virtualbox. Finally, I
installed Developer Suite 10g on Windows XP on Virtualbox.

Report message to a moderator

Re: Please Suggest [message #503171 is a reply to message #503158] Wed, 13 April 2011 06:11 Go to previous messageGo to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
Thanks a lot LITTLEFOOT to inform me about this product but would you please also tell me that my machine doesn't support windows XP therefore its drivers aren't available so will it install on VIRTUALBOX.

Please...?

Report message to a moderator

Re: Please Suggest [message #503175 is a reply to message #503171] Wed, 13 April 2011 06:26 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, that's what I did (Windows 7 host, Windows XP guest operating system). You can install any operating system onto the Virtualbox machine (for example, you could choose one of Linux distributions - just make sure that operating system you install on Virtualbox supports Oracle Developer Suite you plan to use).

Anyway, what do you mean by saying that your computer doesn't support Windows XP? What kind of a computer is it? You don't need any "advanced" features, fast graphics etc. on the guest OS.

Report message to a moderator

Re: Please Suggest [message #503185 is a reply to message #503175] Wed, 13 April 2011 07:20 Go to previous messageGo to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
I am using Dell Inspiron 1564 x64, which support only windows7 and once I tried to install windows XP due to developer suite but system wasn't functioning properly therefore I re-installed windows7 and using forms6i.

I am littlebit confused...

Report message to a moderator

Re: Please Suggest [message #503385 is a reply to message #502981] Fri, 15 April 2011 03:32 Go to previous message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Two Suggestions:


1) I will prefer to make all tables under ABC user and then assigned priviliges to roles and then assigned these roles to any user as per requirement. This is somewhat reversed approached which you have used.

2) Can you retype the procedure again or can you just delete all the lines of present in begin-end block and write one command and then try to recmpile the form? Kindly tell me your result.


--Dude

Report message to a moderator

Previous Topic: frm-41214
Next Topic: forms execute_query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 16:24:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.