for %%i IN (*.fmb) do C:\orant\BIN\ifcmp60 userid=user/pass@orcl module=%%i batch=yes module_type=form compile_all=yes
for %%i IN (*.rdf) do C:\orant\BIN\rwcon60 userid=user/pass@orcl source=%%i stype=rdffile dtype=repfile overwrite=yes
how ya . . . . ???
hi. . . i ve a bored day for my couple days. . . .
it needs so many days that make me rehealt and refresh. . . and you know what??
this printer always scrolls long and after printing has done, and thatalways blinks
i ve to:
*turn off the print.
*scroll barcode paper back
*and turn on again
and the whorse is, it always backs
but in my imagine i can do combine my barcode printer postek /c 168 200DPI with developer 6i
*first, you build generate data to text
*and then you open it (text data generated) with postlable 0.7 software
*open and connecting text data with postlable 0.7 software
*and done!!! you can printing barcode through postlable 0.7 software easly
Ohhhhhhh. . . . . MG’ i ve never been touching my blog for around a week. But. . .
😛 it’s ok, i ve some experience about this one that helped me to import xls file to my Oracle database
i ll implement a faster method to create data from xls file
1. You need to exp your .xls to .csv with save as your xls file
and change file type be comes CSV(text csv)
*Character Set Unicode (UTF-8)
*Filed delimited ,
*and Text delimited “
and then OK and click save
open your .csv file with your text editor till U get data like this below :
“0061031”,”Mr”,”B”,”A”,”Williams A”
“0061032”,”Mr”,”B”,”A”,”Williams B”
“0061033”,”Mr”,”B”,”A”,”Williams C”
and on
2.Create a new file with your text editor and copas scripts below :
explanation
LOAD DATA
INFILE name.csv –>your csv path
APPEND
INTO TABLE RE.contacts –>your table name on your DB
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ –>your column name on your table
(
URN,
TITLE,
FIRST_NAME,
OTHER_NAME,
LAST_NAME
)
this is mine
LOAD DATA
INFILE name.csv
APPEND
INTO TABLE RE.contacts
FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘
(
URN,
TITLE,
FIRST_NAME,
OTHER_NAME,
LAST_NAME
)
save and named file with name.ctl
3.Run your name.ctl on Terminal with :
sqlldr userid=user/pass control=name.ctl
and done!
hope my reviewed could help your problem as mine . . .
have a nice day, keep learning, and see yaaa. . . . .
i’m Using
The target area <location_of_oraInventory> is being written to by another session. A read lock cannot be obtained.
Solution
check your user permission :
sudo chown your_user -R your_oracle_home_path
check your disk space
might be your disk space is fulls fill and can not write some file
it works for me!!!
This section describes how to remove the Oracle HTML DB schema, synonyms, and users from the database without deleting the database.
Open SQL*PLUS and connect as privileged user SYS as SYSDBA
sqlplus sys as sysdba
Execute the following commands:
ALTER SESSION SET CURRENT_SCHEMA = flows_010500;
EXEC wwv_flow_upgrade.drop_public_synonyms;
ALTER SESSION SET CURRENT_SCHEMA = SYSTEM;
DROP USER flows_010500 CASCADE;
DROP USER flows_files CASCADE;
DROP USER htmldb_public_user CASCADE;
done!!
and now your Html DB schema has removed from your database.
🙂 seeeee U!
I ve a problem about remind my APEX admin’s password . . . .
It has along time since i installed my APEX and now,
i need my APEX to develop some Oracle program under web base.
Unfortunately, i’m forgot it . . . i m losing my admin’s password . . .
And good news is. . . . You know what?? i ve a trick to get my admin’s password back.
i try to reset APEX’s password and i ve succeed
let’s check it out here ::
following step by step >>>
1. Connect sys as sysdba
sqlplus sys as sysdba
2. Collect the information of the FLOWS% schema
select username,password,account_status from dba_users where username like ‘FLOW%’;
USERNAME PASSWORD ACCOUNT_STATUS ---------------- ------------------ ---------------- FLOWS_030000 240C2BE199B3DB1F LOCKED -------
3. Unlock the latest FLOWS% schema
alter user FLOWS_030000 account unlock;
4. Change the Password of FLOWS_030000
alter userFLOWS_030000 identified by mypass
conn FLOWS_030000/mypass
connected
5. Create user in Internal Workspace
BEGIN
wwv_flow_api.set_security_group_id(p_security_group_id => 10);
wwv_flow_fnd_user_api.create_fnd_user
(p_user_name => ‘adminq’
,p_email_address => ‘tikusrat@yahoo.com’
,p_web_password => ‘adminq’
);
END;
/PL/SQL procedure successfully completed.
commit;
Commit complete.
6. Open the applications, and Login to Internal Workspace with your new user :
http://your_ip:your_port/pls/htmldb
Login :
– Workspace : Internal
– Username : adminq
– password : adminq
and done!!!
and now you just need to enjoy your coffee and relax!!!
thanks for coming, have a nice day and seee yaaaaa!!!
#source : http://levicorp.com/2010/07/02/how-to-reset-password-in-apex/
. . . . What’s exactly timer function is???
Timer function is kind of trigger that U can use to running your plSql prosedure by timer.
We can create timer function on the all levels of trigger.
And,……on CREATE_TIMER function has three parameters property :
timer name
timer time
timer process
and on “timer process” has 2 parameters :
REPEAT
and
NO_REPEAT
1. Create XTIMER procedure as below :
PROCEDURE XTIMER IS
timer_id TIMER;
timer_interval NUMBER := 1000;
BEGINtimer_id := CREATE_TIMER(‘timerq’,timer_interval,REPEAT);
END;
2. Create WHEN-NEW-FORM-INSTANCE trigger on the form level
3. Put XTIMER; procedure on WHEN-NEW-FORM-INSTANCE
4. Create WHEN-TIME-EXPIRED trigger on the form level too
(Put PLSQL function here to execute PLSQL functions when time has expired)
Descriptions :
On the “time_interval NUMBER :=1000;”
it means 1000 as 1 second
hi i ve something 4 U . . . .
it just simple to do . . . . . .
1. Create item and set property “sound”
2. Put the code below on when_button_pressed
Go_Item(‘your_sound_item_property‘);
Read_Sound_File(‘path_of_your_waves_file‘, ‘WAVE’, ‘your_sound_item_property‘);
Play_Sound(‘your_sound_item_property‘);
mine
Go_Item(‘top_bar.playx‘);
Read_Sound_File(‘E:bird_hawk.wav‘, ‘WAVE’, ‘top_bar.playx‘);
Play_Sound(‘top_bar.playx‘);
and done . . . . .
U can develop this, as long as U can do . . . . might be some alarms, thats U can use trigger by timer . . . or some thing else
hope that was worth 4 expand your knowledge . . .
that s a wrap to day . . . . seeee yaaaa!! 🙂
hi i ve some thing 4 U. . . . .
that’s nice to share something with some one and hope it’s going to help U . . . .
it calls
yeah it some functions to describe number to character in indonesian currency . . . . it should like “dua ribu rupiah” seribu limaratus rupiah . . .
end else . . . . . and U can use oracle_terbilang functions here : Continue reading
Ok . . . . i ve a simple way How to install Oracle Designer 6i Repository . . . .
1. download my designer.sql file here :
2. run the file as sys dba privilege :
sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on Sat Mar 10 13:01:45 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL>
and run the sql file with :
SQL>@designer.sql
wait the generate process until finish . . . . after all preparation, log into your designer 6i with :
user : designer
pass : password
3. Go to Repository Administration Utility >>
configure your designer repository with
*DESIGNER,
*DESIGNER_INDEX,
*DESIGNER_TEMP tables space
and then?? start installation!!!
It should need very long time to wait installation progress . . . .
So, have a time to make a glass of coffee
after finished the installation . . . . . .
enjoy design your table . . . !!!
#i’m using :
ice cream gear 