Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tabular form "calculated column"

Waqas Ali JoyaNov 8 2013

Hi guys,

I have built a tabular form. I have a column name 'Amount' in the table on which tabular form is made. Then i added two non-table columns 'Amount1' and 'Amount2' by editing the query of the tabular form. Both are null initially. i.e.

Select ... , Amount, null Amount1, null Amount2 from t_table;

Both of these non-table columns are displayed as text fields.

The purpose of these two non-table columns is that before insert or update operation the values in these non-table columns will be added and sum will go into the original database column 'Amount'. i.e.

Amount=Amount1+Amount2;

But i am getting an error saying "current version of data in database has changed since user initiated update process".

If i display these two non-table columns as simple text (does not save state) there is no problem. But i have to use these as text fields.

As far as i remember it can easily done in oracle forms in before insert update trigger.

I am using Apex 4.2.

Please help.

Regards

Waqas

Comments

Helios-GunesEROL
Hi;

Please check:
How To Prevent The Secure Password Store Wallet From Being Moved to Another Host [ID 1114599.1]

Regard
Helios
862820
Hi Helios,

Thanks for your reply. I couldn't find thread you mentioned. The closest match I could find was -

http://www.myoraclesupports.com/content/how-prevent-secure-password-store-wallet-being-moved-another-host

Tried the suggested stuff here, but the problem still seems to be same. (I added an entry to my windows host file also as suggested here)

Thanks
Sachin
Aman....
But that wasn't a thread but an article on the support web site. Are you sure you logged in to it and couldn't find the article actually?

Aman....
862820
Yep tried,

Do you have the link to that post/thread?

Thanks
Sachin
Aman....
Hmm, I have just checked and the document is there. Did you go to https://support.oracle.com (don't use that myoraclesupport website, it's a fake) and searched for it in the Knowledge Base?

Aman....
862820
Hey Aman....

Thanks. Unfortunately the info at the support site is exactly the same as what was present in the earlier link I mentioned and neither of them worked for my case :(

Still stuck with the issue. Wondering if it is the 11G R2 issues specifically....

Anyone got a clue....

Thanks
Sachin
862820
This issue didn't get solve and I had no other option but to downgrade the Database from 11G Release 2 to 11G Release 1. Once I put the R1, wallet was working fine.

Sachin
675403
Hi,
I had the same issue on my Window 7 laptop and saw your thread as I was attempting to troubleshoot it. I figured it out and I'd like to share how. I turned on the Sysinternals tool Process Monitor and tried startup again. After the failure I stopped collecting data in process monitor. I filtered the output to include lines with .sso or .p12 which are the extensions on my two Wallet files. It showed me that the issue was ACCESS DENIED to the NT_AUTHORITY\SYSTEM account when accessing those two files. SYSTEM is the account my local test Oracle instance runs under. I granted the rights to SYSTEM for those two files and now my database is working.
Joe
Texas
Hi Joe,


How did you grant SYSTEM (db user) the rights for those two files on OS level?
Azar
Is this following post may helpful for you?

http://mohamedazar.com/2012/03/25/how-to-configure-clients-to-use-external-password-stores/
Texas
Thanks a lot.

Though, my wallet is working when I connect via sqlplus.

Where I'm having issues is, I want to use it for DataPump export job ... that is where I got the error:
ORA-12578: TNS:wallet open failed


Any hint on that?

Thanks for your response.
Azar
Can you paste your sqlnet.ora file here?
Texas
Here it is:

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)(METHOD_DATA =
(DIRECTORY = /oracle/product/11.2.0/ddw7/network/admin)))

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
Azar
Change TRUE to FALSE and try, Usually this parameter is useful for who want connect particular schema from client machine, you can configure this parameter in client machine and configure which schema you want to connect without schema name and password.

I don't think so If this parameter is enabled in server, you can able to take export or connect other schema in database

SQLNET.WALLET_OVERRIDE = FALSE
Texas
I tried that earlier, it ain't working.


UDE-01017: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied
Texas
Another point, I am using the wallet on the server for export job but all sqlplus connection using it was successfull.
Azar
what is your expdp command?
Texas
expdp /@ddw7 SCHEMAS=SO_DL,SO_IL ESTIMATE_ONLY=y NOLOGFILE=y


but when I do:

sqlplus /@ddw7, it works perfectly without prompting for anything ..
Azar
Not sure ,Without supply username and password datapump is support.
Texas
Thanks for your time though.
ote

Hi,

give the Windows SYSTEM account read permissions to the files ewallet.p12 and cwallet.sso. Expdp and  impdp are working with the SYSTEM account and need to read these files.

Greets

OTE

1 - 21
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2013
Added on Nov 8 2013
0 comments
200 views