Skip to Main Content
Forums

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!

can not create a base translation from fmb files

guizani.seifApr 24 2014 — edited Apr 24 2014

Hi,

windows server 2008 R2 Enterprise (64 bit)

Oracle 11g release 11.2.0.1.0

-------------------------------------

After installing TranslationHub 11g 11.1.2.0, I want to create a base translation but unfortunately I can not achieve it!

when I read http://www.oracle.com/technetwork/developer-tools/forms/oracletranslationhub11g-198892-en-gb.pdf and exactly page 6, Creating a base translation,

when I follow the steps

and when I click on 'Select files...' button of the 'Import base language files' dialog, I find as a file type choice *.rex only. Or I want to do it from a .fmb file.

How can I fix this please.

Thanks.
This post has been answered by guizani.seif on Apr 24 2014
Jump to Answer

Comments

Christian.Shay -Oracle

Hi,
Please execute this making appropriate substitutions for VIEW_NAME and VIEW_OWNER:

select
dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'VIEW_OWNER') 
from
dual;

Or you can try:

SELECT VIEW_NAME, TEXT
FROM USER_VIEWS;
User_C54NY

Hi,
I tried the first one but have problems to replace accordingly.
2021-10-14_14-22.pngSo, I put:

select
dbms_metadata.get_ddl('ALL_VIEW_SOURCE', 'ALB') 
from
dual;

But who is meant by owner?
Is it the username which is used to establish the connection? The host name? Connection Name?
"Dual" should be used as given?
Thanks!

undefined (0 Bytes)undefined (0 Bytes)In your case, please try this:

select
dbms_metadata.get_ddl('VIEW', 'ALL_VIEW_SOURCE', 'AWS_DEV_ALB') 
from
dual;
User_C54NY

Thanks, it took me one step further.
I right clicked on AWS_DEV_ALB -> "open new sql file"
2021-10-15_10-48.png
and pasted what you provided:

select
dbms_metadata.get_ddl('VIEW', 'ALL_VIEW_SOURCE', 'AWS_DEV_ALB') 
from
dual;

I right click on the query and "execute sql" but all I get is:
2021-10-15_10-58.pngIf that's relevant, the structure is:
2021-10-15_10-59.pngThe view I want is in "Relational Views" file order.

Answer

You greyed out the view name, so I cannot check to see if you have a typo which is the first thing I would suspect.
Did you give the view name in all caps, surrounded by single quotes?
Maybe you can create a view called TESTVIEW and run this again using 'TESTVIEW' as the second parameter and share the full error message without greying it out.
Finally, please issue:
select owner from ALL_VIEWS where VIEW_NAME ='NAMEOFYOURVIEW';

If that is NOT AWS_DEV_ALB then you will need to change the pl/sql block accordingly.

Marked as Answer by User_C54NY · Oct 18 2021
1 person found this helpful
User_C54NY

The owner it was. With your second view I got the owner, changed it and it worked. Thank you very much for your patience! Just for clearance and everybody else who might have problems with it. Owner is the name you fill in to connect to your database. What I used before - and what didn't work - was the name I gave for the connection.
Screenshot 2021-10-18 103155.jpg

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

Post Details

Locked on May 22 2014
Added on Apr 24 2014
#forms, #moved-from-devops
1 comment
957 views