Prev: TRichEdit mit formatiertem Inhalt initialisieren
Next: any way to speed up count(*)?
From: N.M. on 24 Nov 2009 02:43
Hello!

My client told me that one Oracle form behaves strangly.
We (as programmers) use Oracle Forms ver 6 with all patches released and
installed.
Our client has Oracle 9 version.

The problems looks like this:
While clicking on "Confirm button" located on the form, it runs database
packages functions which update and insert data into database tables. After
it, there is forms_ddl('commit') run and now it gives strange errors.
While running this form localy and clicking "Confirm button" (it means the
oracle forms` files ale located on the net disk and Oracle application runs
by local user/computer) everything works perfectly and there is no strange
errors/messages on the screen.
While running this Oracle application form using remote desktop window and
clicking "Confirm button" there is a error message "FRM-40401: No changes to
save". This errors generates many times because strored procedures`
functions run inside the loop.

My client told me that this error (such error message) is generated only
when he runs the application form via remote desktop.

Do you have any idea what can be wrong?
Thank you in advance
netman


From: Mark D Powell on 24 Nov 2009 10:40
On Nov 24, 2:43 am, "N.M." <net...(a)poczta.onet.pl> wrote:
> Hello!
>
> My client told me that one Oracle form behaves strangly.
> We (as programmers) use Oracle Forms ver 6 with all patches released and
> installed.
> Our client has Oracle 9 version.
>
> The problems looks like this:
> While clicking on "Confirm button" located on the form, it runs database
> packages functions which update and insert data into database tables. After
> it, there is forms_ddl('commit') run and now it gives strange errors.
> While running this form localy and clicking "Confirm button" (it means the
> oracle forms` files ale located on the net disk and Oracle application runs
> by local user/computer) everything works perfectly and there is no strange
> errors/messages on the screen.
> While running this Oracle application form using remote desktop window and
> clicking "Confirm button" there is a error message "FRM-40401: No changes to
> save". This errors generates many times because  strored procedures`
> functions run inside the loop.
>
> My client told me that this error (such error message) is generated only
> when he runs the application form via remote desktop.
>
> Do you have any idea what can be wrong?
> Thank you in advance
> netman

I am not a developer so I had not seen your issue but I have some
questions that might help you get a response:

Are you running the server based or client based version of Forms 6?
Are you running character based or GUI?
What is the full Oracle version of the database?
What is the full Oracle version of the client?

We run server based character mode 6i and in the past we had an issue
that if we did an rlogin and then executes our Forms based application
you would get an error. When you log in directly to the application
server and run from there it ran fine. Your issue seems similar, but
our solution was just to login directly and run locally.

With the above information it should be possible to search My Oracle
Support and see if you can find any matching error reports.

You probably should have posted this to comp.databases.oracle.tools
rather than misc but most of the views are the same people so I am not
sure reposting is necessary though that would be up to you.

HTH -- Mark D Powell --




From: Shakespeare on 24 Nov 2009 11:33
N.M. schreef:
> Hello!
>
> My client told me that one Oracle form behaves strangly.
> We (as programmers) use Oracle Forms ver 6 with all patches released and
> installed.
> Our client has Oracle 9 version.
>
> The problems looks like this:
> While clicking on "Confirm button" located on the form, it runs database
> packages functions which update and insert data into database tables. After
> it, there is forms_ddl('commit') run and now it gives strange errors.
> While running this form localy and clicking "Confirm button" (it means the
> oracle forms` files ale located on the net disk and Oracle application runs
> by local user/computer) everything works perfectly and there is no strange
> errors/messages on the screen.
> While running this Oracle application form using remote desktop window and
> clicking "Confirm button" there is a error message "FRM-40401: No changes to
> save". This errors generates many times because strored procedures`
> functions run inside the loop.
>
> My client told me that this error (such error message) is generated only
> when he runs the application form via remote desktop.
>
> Do you have any idea what can be wrong?
> Thank you in advance
> netman
>
>
I guess you are using client server forms, right?
I vaguely remember that with forms (Client Server) you need access to
the root directory of c:\. You may not have access on your remote
desktop session.

Shakespeare
From: Shakespeare on 24 Nov 2009 11:53
N.M. schreef:
> Hello!
>
> My client told me that one Oracle form behaves strangly.
> We (as programmers) use Oracle Forms ver 6 with all patches released and
> installed.
> Our client has Oracle 9 version.
>
> The problems looks like this:
> While clicking on "Confirm button" located on the form, it runs database
> packages functions which update and insert data into database tables. After
> it, there is forms_ddl('commit') run and now it gives strange errors.
> While running this form localy and clicking "Confirm button" (it means the
> oracle forms` files ale located on the net disk and Oracle application runs
> by local user/computer) everything works perfectly and there is no strange
> errors/messages on the screen.
> While running this Oracle application form using remote desktop window and
> clicking "Confirm button" there is a error message "FRM-40401: No changes to
> save". This errors generates many times because strored procedures`
> functions run inside the loop.
>
> My client told me that this error (such error message) is generated only
> when he runs the application form via remote desktop.
>
> Do you have any idea what can be wrong?
> Thank you in advance
> netman
>
>

Just checking: are you connecting to the SAME pc using remote desktop as
when you run it locally?

Shakespeare
From: N.M. on 25 Nov 2009 04:02

Uzytkownik "Shakespeare" <whatsin(a)xs4all.nl> napisal w wiadomosci
news:4b0c0ab8$0$22917$e4fe514c(a)news.xs4all.nl...
> N.M. schreef:
>> Hello!
>>
>> My client told me that one Oracle form behaves strangly.
>> We (as programmers) use Oracle Forms ver 6 with all patches released and
>> installed.
>> Our client has Oracle 9 version.
>>
>> The problems looks like this:
>> While clicking on "Confirm button" located on the form, it runs database
>> packages functions which update and insert data into database tables.
>> After it, there is forms_ddl('commit') run and now it gives strange
>> errors.
>> While running this form localy and clicking "Confirm button" (it means
>> the oracle forms` files ale located on the net disk and Oracle
>> application runs by local user/computer) everything works perfectly and
>> there is no strange errors/messages on the screen.
>> While running this Oracle application form using remote desktop window
>> and clicking "Confirm button" there is a error message "FRM-40401: No
>> changes to save". This errors generates many times because strored
>> procedures` functions run inside the loop.
>>
>> My client told me that this error (such error message) is generated only
>> when he runs the application form via remote desktop.
>>
>> Do you have any idea what can be wrong?
>> Thank you in advance
>> netman
> I guess you are using client server forms, right?
> I vaguely remember that with forms (Client Server) you need access to the
> root directory of c:\. You may not have access on your remote desktop
> session.
>
> Shakespeare

I think that I have the answer on my problem.

There are 3 buttons on the form. There is "commit;" command use inside one
of the form buttons
(only one). The other buttons have "forms_ddl('commit');" use. The problem
with this error
message display occurs only while using the button which have "commit;"
command
only if the form is running via remote desktop. When the user runs the
Oracle application
localy or via net drive, this error message doesn`t occur.
Inside the "commit;" command use button, there are no form changes made,
there is only
one INSERT INTO table statement query before "commit;" command use.
I am not sure that this INSERT INTO table statement is committed/saved into
the databes
when the "commit;" command is used, instead of forms_ddl('commit'); use
which will save
(into the database) the INSERT INTO statement for 100% sure.

netman


 |  Next  |  Last
Pages: 1 2
Prev: TRichEdit mit formatiertem Inhalt initialisieren
Next: any way to speed up count(*)?