MUSTAFA ELSHIEKH

I am working with an HIS application, which works on Forms builder 6i and on oracle Database 6.

Recently I installed Oracle forms builder 6i on Database 8i.

Unfortanetly faced some errors, but i stucked at the end on this:

The Program is lunched fine, but the push buttons are not working
ex) The main menu consists of many push buttons, each button will call the form needed.

Note: The Company created the Program gave us the runtime only, there is no way to recompile the forms again.

While on DB 6, the push button is calling other forms fine.


Hopefully there is anyone who can help.

Regards,
Mustafa El-Shiekh.
[ October 25, 2005: Message edited by: MUSTAFA ELSHIEKH ]

Dear Ahmad,

Can you describe the three tables, and post them , not forgetting to show the error too.

Regards.

I will tell you in details what is my situation:

I am using Oracle DB 10g with oracle forms builder 6.0.8.7
When Running the program, an error appears as am not authorized to run menu builder, while i gave the system user all the roles needed or even not needed!!

A searched from the net for this error, and they asked to run the script:
@$JS_TOP/sql/frm45sec.sql

I searched for this within my database scripts or forms scripts but didnt find them!!??!!

what shall i do now!! i thought if i got the script, i would at least copy it and paste it to SQL!!

Hello,


I am looking for something like these scripts:

install.jsadmin or frm45sec.sql


Thanks.

Hello,

can anyone tell me from where i could download oracle database scripts??!

thanks.

Hi to all,

I faced this error in more than one occasion telling:
FRM-10256: User not authorized to run Form Builder Menu.

This comes once i try to run a newly installed Program,
the error appeared for on both operating systems winXP and 2003.

Unfortanitly some solutions tell that the roles are incorrect "the select is missing", but it's not.

Another asks to run script: install.jsadmin which calls : frm45sec.sql
but i guess this is an old version of forms builder!!

Any idea on whats happening?!!! or whats the solution!!

Regards,
Mo.

thanks to all who replied!!

well i found a long way solution, which will be :
exit_form(no_validate);
which will allow you to exit the form without saving or showing this message, and could also be used on saving too.

Regards,
Mustafa

Creating a procedure or trigger is a good idea,
but for myself i prefer cordinating the file on an excel sheet,
simply change what you need and then convert it by the sqlloader to your database.

Regards,
Mustafa.

hi Jeanne,

ok thats fine with me, but i didn't get any previous notice about "questions policies", and secondly if i had some questions it will be healpfull questions not real ones, specially that this exam i already passed almost a year ago.
am an OCP sinse febuary 2004!!

sorry again for this, please accept my appologies.

Best Regards,
Mustafa El-Shiekh.

hello,

please just check your TNSNAMES.ora file and the listener too,
and check if the listener is started on the Administrative tools.

then check it again.

Regards,
Mustafa.

Hello friend,

I am an Oracle 9i OCP,
I've passed Fundamentals I and i think it is very easy considering with the coming ones!!
just concentrate on Tablespaces.
and i can help you with some questions still on mind.

Regards,
Mustafa.
[ January 11, 2005: Message edited by: Jeanne Boyarsky ]

hi there,
am with mark, the best way is going through roles and priveleges created for each and every type of users you create, it will be very helpfull for later on transactions.

Regards,
Mustafa.

I am using Oracle forms builder 6, and i want to cancel the message :
"Do you want to save the changes you have made?" generated by oracle itself.
It is not an error message with numberic code so we can cancel it by ON_MESSAGE trigger!!
Is there any way it could be done.

Regards.

on windows operating system, i need to create a batch file which will logon to SQL plus with my userid and then run a command as DELETE..
I already did step one,
SQLPLUS user/password@domain --> which will opens a command promp screen connected directly to SQL with that userid , but anything written after that in the batch file will be ignored.
Is there any possibilities to run a command through the batch file into the sql?! like for example DELETE.

Hi all,
I already read about this error, but i have a different situation, I am a DBA in a site that is already running fine and smooth, the next day this error is shown on 40% of the computers in the site, thinking it might be from thr TNS names but its not, and i checked the NLS_LANG and still not, i even thought it might be from the clients so i made image for getting sure from it, but still no solution. What is the possibility of having a virus in here, or if someone faced it before i will be thankfull for your helf.
Mustafa El-Shiekh.