Can't Run Form by another user !

[shahab]

Hi
I've compiled a form and generated an FMX for example by SCOTT user.I've duplicate the SCOTT schema to user SCOTT2.
when i want to run FMX by user SCOTT2 via F50RUN32.. it can not run.i must recompile the FMB and again generatin the FMX by user SCOTT2 and then i can run it.
What's the Problem?
Is FMX sensitive to user that compiled by?

Thanks
Shahab

[JChiappa]

No, the problem here is : when you build a form, it writes some small programs (triggers) to check the constraints, this way :

SELECT nnn FROM SCOTT.EMP
where ....

To run this form in another user, just remove the SCOTT. parts in all PL/SQL triggers.

[]s
Chiappa



Author Thread

shahab
Junior Member

Registered: Sep 2000
Posts: 7

Hi
I've compiled a form and generated an FMX for example by SCOTT user.I've duplicate the SCOTT schema to user SCOTT2.
when i want to run FMX by user SCOTT2 via F50RUN32.. it can not run.i must recompile the FMB and again generatin the FMX by user SCOTT2 and then i can run it.
What's the Problem?
Is FMX sensitive to user that compiled by?

Thanks
Shahab

[shahab]

dear Jchiappa

I think you are right ; yhese forms are genetrated by Designer/2000 and i think he do it as default.
i'm going to test it.

thanks a lot :)
Shahab