All Questions
Tagged with oracleforms oracle11g
177 questions
0
votes
1
answer
214
views
How to automatically load the database name when launching an Oracle Forms 11g application?
In fact, I want the user to fill in only the username and password without knowing what the name of the database is. I tried with the formsweb.cfg file and the env file but it doesn't work. Then I ...
- 239
0
votes
1
answer
360
views
How to draw charts(Graphs) in Oracle Form (11g & above)
i want to draw charts(pie and
bar charts ) in oracle form
builder using bean component in oracle form block.
SET_CUSTOM_PROPERTY()
using bean property as mentioned above. If anyone refers to or share ...
- 3
0
votes
2
answers
123
views
How to copy a list data into the TextField with Single-line
How I can copy a list value below into TextField with Single-line?
A20230101001
A20230101002
A20230101003
A20230101004
The issue is when I copy this list into TextField then it just only the value ...
- 151
0
votes
1
answer
444
views
In multi record form how to set focus on 5th record when new form instance in Oracle forms 10g
In Oracle 10g forms developer i have 2 forms one is search form another is details.details form is multi record form.wgen details form opens cursor points to first record by default.(out of 10 records ...
0
votes
1
answer
255
views
Can I Run both Oracle Forms 10g DS and Oracle Forms 11g on same machine?
I have installed both Oracle Forms 10g DS and Oracle Forms 11g on same OS (windows) and same machine. At first I install 10g DS and it run then I install 11g in the same machine. After install of 11g ...
- 1
0
votes
1
answer
301
views
PL/SQL Query to check row's length
I'm having some trouble on solving this.
I have to check on the table, if there's any row that exceed the length of 34 characters (for this, I'm using this first part of the query using Lenght command)...
- 9
1
vote
0
answers
142
views
How to download oracle form attachments using concurrent program
I'm having a requirement, which is to download the attachments in the in the form or FNDLOBS using the concurrent program (A zip or PDF file should get downloaded in the browser once the concurrent ...
- 11
0
votes
1
answer
674
views
PL/SQL frm-40735 ora-305500 error message
using oracle forms and sql developer.
trying to transfer the amounts in my tables to excel. In doing so, I need to divide a month into four weeks.
I tried to check each week in an if elsif loop. To ...
- 37
0
votes
3
answers
4k
views
Oracle Forms - How to open a URL in Chrome
Is there a way to open a URL within forms, in another browser other than explorer?
Currently running web.show_document(url, '_blank');' only opens it in explorer.
For a reason I am unable to use the ...
- 531
0
votes
1
answer
442
views
how to create a trigger for Shift + A key press in oracle forms 12c
In oracle form builder, I want to use a trigger for Shift + A, (it just cant be any other key, dont ask me why please), but there are only a few specific KEY- triggers available. I just want to run ...
1
vote
0
answers
875
views
How to display arabic characters in forms 6i?
We have a very old application developed in Developer 2000 (Forms 6i), the Arabic characters are displayed as junk characters on the form fields.
The database is 11g and the data is available in ...
- 307
0
votes
1
answer
156
views
dbms_random.value works fine with code below except need to change date by assigned field
Dear I have this code which is work fine it generate random time which is generated till the last record found I have 2 fields where is :C field have date with different I can generate random time but ...
- 83
0
votes
1
answer
338
views
oracle forms 12c can I get application on internet like web no client installation [closed]
Dear all can I get oracle 12C application access as web on internet I know this process will not as all can be explained here but someone please guide me in which way I have to go lead me how can I ...
- 83
-1
votes
1
answer
260
views
join condition with or
i have a form which contains
two database blocks A and B.
they are related by master detail (join) condition:
A.account=B.account
account is a type varchar2(10).
it works fine.
but the problem is ...
- 17
0
votes
1
answer
188
views
Oracle Forms 6i Err: 201 Identifire or No Column In Table
Can anybody help ?
I Have a table Named "Cut_Issue" One of its column is "TRANS_NO".
The Code is:
Select Trans_No
into :Cut_issue.Trans_NO
from Mlang.cut_issue
where Trans_No = :...
