suppose you want to run welcome.html from oracle 9i server.
Login to oracle 9i server
$ cd $ORACLE_HOME
$ cd web/html/tool
copy your welcome.html file in this directory.
Then in web browser write :
http://<ipaddress>:<po rtnumber>/forms/html/welcome.html
Press enter. This will invoke your welcome.html
Hope this helps !!...
anuj13singhal
Last Activity: May 1 '07, 11:33 AM
Joined: Jan 11 '07
Location:
-
Hi,
Perform the following steps
on button pressed trigger write the following code
...Code:declare v varchar2(1); begin select 'X' into v from table_name where username = :block2.username and password = :block2.password; if v='X' then call_form('form_name'); else message('Please enter username and password again'); :block2.password := null; :block2.usernameLeave a comment:
-
-------------------------------------------------------------------------------------------------------------------
Hi,
Perform the following steps:
1) Go to Start --> Programs --> Oracle developer suite DevSuite1 --> forms developer --> Start OC4J instance.
2) A black screen will open and at the bottom of it, "initialize d" is writen.
3) Compile your form and genertate...Leave a comment:
-
I hav send the answer to your mail id....Leave a comment:
-
-------------------------------------------------------------------------------------------------------------------
Here is the program :
declare
n number(10) := &num_element s;
temp number(10) := 0;
begin
for i in 1..n loop
temp := i+temp;
dbms_output.put _line(temp);
end loop;
end;
Hope this will help !!...Leave a comment:
-
-------------------------------------------------------------------------------------------------------------------
Hi,
Could you please try the query :
insert into dept(salary) as select e.salary from emp e, dept d where e.name=d.name;
hope this works !!...Leave a comment:
-
-------------------------------------------------------------------------------------------------------------------
If you have SQL loader file eg test_loader.ctl in the unix directory then write the following command to execute it
$ sqlldr userid=userid/password control=test_lo ader.ctl log=test_loader .log &
hope this works !!!!!!!!!...Leave a comment:
-
------------------------------------------------------------------------------------------------------------------
Suppose your userid item name is userid_1 and password item name is password_1 and your block name is block2
In button press trigger of go button write :
declare
cursor c1(uid,pwd) is select * from login where userid=uid and password=pwd;
userid1 varchar2(20);
passwd varchar2(20);...Leave a comment:
-
----------------------------------------------------------------------------------------------------------------
Hi,
In button presses trigger write:
call_form('SHIP MENT'); -- if it doesnot work then give the full path of the form
you can also call the another form like this :
open_form('SHIP MENT'); -- if it doesnot work then give the full path of the form
Hope...Leave a comment:
-
-------------------------------------------------------------------------------------------------------------------
Hi Romi,
Suppose your block name is block2 and your text item name is text_item1 and you have written 'romi' in the textbox.
Create a button (drag and drop) and on button pressed trigger write:
insert into table_name values(:block2. text_item1);
commit;
...Leave a comment:
-
Hi Anita,
Case Sensitivity in oracle is with the object names and object columns also.
Suppose you want to create a table NaMes having a coloumn FirsT_NaMe (note the cases).
so, you can create this like :
create table "NaMes" (FirsT_NaMe varchar2(20));
And select like this:
select "FirsT_NaMe " from "NaMes";
if you write...Leave a comment:
-
Hi,
You can install your Report builder 6i in the oracle 9i home itself, There is no need to create a new home for it. Forms and reports 6i are compatiable with oracle 9i database....Leave a comment:
-
Calling word application from oracle forms 10g
Hi,
I am trying to open a word document on the client machine. the document is present on the oracle application server (on windows).
For that I have created a java class file wordbean.class. (Source code below)
package oracle.forms.de mos.ole;
import com.jacob.activ eX.ActiveXCompo nent;
import java.awt.Panel;
import com.jacob.com.* ;
public class wordbean extends Panel...
No activity results to display
Leave a comment: