Skip to Main Content

Oracle Forms

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refresh block

863006Jun 26 2012 — edited Jun 28 2012
Hi all,
I'm using Oracle Forms Builder 10GR2. I have a database block and a procedure which just updates the values of some fields in that DB block. The problem is that the new values don't appear immediately even i have specified commit in the procedure. I have to requery the database block to see the new values. Any ideas how this can be achieved? Also, i tried to specify an INTO clause for those fields but i think this is not working because of their database item property...

In other block, which is not database, i have something like this :
select <value> INTO :<field> FROM <table_name>
and the value of that field is automatically refreshed. Is this going to work for db items? If yes, why i'm not able to compile my procedure when the syntax is the same as the non-db items? The error is : Bad bind variable....



Thanks in advance,
Bahchevanov.

Comments

JustinCave
Oracle database patches are available from http://metalink.oracle.com Why are you trying to download a patch from a non-Oracle domain? That's almost certainly a violation of copyright and there is a substantial risk that you're downloading an infected patch.

Justin
Hussein Sawwan-Oracle
I can open https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1159443.1 with no issues.

Have you tried to use a different browser and/or a different machine?

What is the patch number you are trying to download? Instead of downloading it from the link you have posted above, go directly to My Oracle Support (MOS) website, click on "Patches & Updates" tab, search for the patch number and download it from there -- https://support.oracle.com

Thanks,
Hussein
888953
----------
I can open https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1159443.1 with no issues.

Have you tried to use a different browser and/or a different machine?

What is the patch number you are trying to download? Instead of downloading it from the link you have posted above, go directly to My Oracle Support (MOS) website, click on "Patches & Updates" tab, search for the patch number and download it from there -- https://support.oracle.com

Thanks,
Hussein
--------------------------
Yes, I did go to https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1159443.1 and it gave me the error message. I tried other browsers (ie, firefox, safari) and other machines but still encountered same error message.

I also went to https://support.oracle.com. It asked me to 'Sign in' which I did. Then it asked me to enter CSI number. It is a compulsory field and I don't have that. I am using free oracle 10g express edition. So there is no contract between me and oracle for CSI, I think.

Is that other way to patch oracle 10g express edition? I am frustrated by this process. Oracle make express edition so easy to download. Yet it is so difficult to download patch.
Hussein Sawwan-Oracle
Yes, I did go to https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1159443.1 and it gave me the error message. I tried other browsers (ie, firefox, safari) and other machines but still encountered same error message.

I also went to https://support.oracle.com. It asked me to 'Sign in' which I did. Then it asked me to enter CSI number. It is a compulsory field and I don't have that. I am using free oracle 10g express edition. So there is no contract between me and oracle for CSI, I think.
This is an expected behavior if you do not have a CSI number.
Is that other way to patch oracle 10g express edition? I am frustrated by this process. Oracle make express edition so easy to download. Yet it is so difficult to download patch.
What is the patch number you are trying to download?

Thanks,
Hussein
888953
Thank you Hussein.

I need 2 CPU for Oracle 10g express release 2
October 2010 CPU
January 2011 CPU

Is there a direct way to download them?
Hussein Sawwan-Oracle
I need 2 CPU for Oracle 10g express release 2
October 2010 CPU
January 2011 CPU
Do you have any patch numbers? IINM, you do not need to apply CPU patches for Oracle XE, that's why I am asking about the numbers. Or, what is reason you need to apply those patches?
Is there a direct way to download them?
The only way to do is via MOS/Metalink website which requires a valid username/password and CSI number.

Thanks,
Hussein
888953
My security guy detects the vulnerability of Oracle XE on my server. So I need to apply the patches.

For Oracle XE without CSI, is it still possible to apply the patches?
Hussein Sawwan-Oracle
My security guy detects the vulnerability of Oracle XE on my server. So I need to apply the patches.
What vulnerability we are talking about here? Any details? How do you know it is related to Oracle XE?
For Oracle XE without CSI, is it still possible to apply the patches?
Most Oracle Database Patches (if not all) are available on MOS website only.

Thanks,
Hussein
888953
Security guy detect vulnerability on port 1521 which belongs to Oracle XE. And they point out it is database and show me the 2 websites below:

http://www.oracle.com/technetwork/topics/security/cpujan2011-194091.html
http://www.oracle.com/technetwork/topics/security/cpuoct2010-175626.html

I am afraid I can't tell them Oracle XE does not need patch. Yet I don't have access to patches. This really a dilemma.
orafad
Answer
user3169384 wrote:
My security guy detects the vulnerability of Oracle XE on my server. So I need to apply the patches.
Please re-read the license agreement for XE, specially the part about updates.

There are no patches. If you "need" to then you should consider paying up and going to Standard or Enterprise Edition.

An alternative way might be migrating to 11.2 XE (which is 11.2.0.2 version, maybe good enough).
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
Marked as Answer by 888953 · Sep 27 2020
888953
Thanks everyone for you replies.

I get it now that express edition is not supported by patches. Sorry I did not read license agreement carefully. I don't read license agreement for paid software either -)

I did not install 11g express edition because I did not find migrate tools in it. It seems to be a fresh installation. Correct me if I am wrong here. The solution I can think of is to install 11g on a new machine and copy my data from 10g to 11g. I don't have that luxury.

The workaround I have now is to configure firewall to limit port 1521 to certain machines (hosting web applications) only. That way I have peace of mind that my Oracle will not be hacked.
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 26 2012
Added on Jun 26 2012
12 comments
4,594 views