Dear expert,
I used this in Forms 6i with Oracle8i and GET_FILE_NAME() worked fine. I just upgraded to Oracle9i/Forms9i and it doesn't open dialog window.
The following code compiles ju...
Im trying to call another form(FORM B) from FORM A, and pass a parameter. This parameter, say EMPNO, should automatically be moved to a data block item in Form B, and it should execute the que...
Hi,
I'm trying to find a book on Quest SQL Navigator 4 but have had no luck.
I'm even considering going on a course.
Does anybody know of any of these for SQL Nav?
Why am I finding...
We are running a PeopleSoft app engine process that processes a high volume of bill lines to calculate taxes (using Vertex.) The issue seems to be an Oracle "feature" that can (but not always)...
We use MSDAORA to connect SQL Server 2000 with Oracle 8.06.20 using linked
server through Oracle Client 8.1.7. It works fine with simple SELECT statements. However as soon as we placed a WHER...
I have certain constraints on the DB. When I load a file using SQL*Loader, however, the constraints are violated. Why does this happen? Is there any way to ignore the violating records, and co...
Hi Experts
I am using Dev 9ids. And i am compiling every forms from form 5 to form 9i. and report too.
Most of reports are running.
in some i am getting problem where i do pass more th...
Hi,
I whant to have a form that will be used for monthly processing by calling a number of stored procedures. Succesfully ended procedure should change the active list element to next one and...
I am having a problem with my form. I am able to query and insert but when I try to update or delete I receive the following error:
FRM-40735:LOCK-PROCEDURE trigger raised unhandled except...
The stored proc for the most part seems to work however when it get a certain p_emp value I get then error 6502 ORA-06502: PL/SQL: numeric or value error. The p_emp does exist so there are no ...
Hello to all,
I created a hierarchical tree for my table with self join. Here I display all data from that table.
Next to the tree, I created a data block, there I see all my table's data ...
Hello, I came back with my question about hierarchical tree.
htree := Find_item('MyTree');
new_node := Ftree.Add_tree_node(htree,
Ftree.root_node, Ftree.p...
All,
Writing a query in MS XL VBA to access an Orcale module (DSS) via ODBC. Is it possible to construct an SQL statement that will list all of the table names?
Also, is there an online...
Running Informatica (V ) over Oracle database on Unix Server.
Is there a way we can automate (read Batch job) the folder copies from Dev Repository to Prod Repository. Drag and Drop is OK,...
Hello all,
I'm new to using Toad and have a small problem.
When making a new connection there is a database drop down box that includes some of the databases I need but not all. I can...
Hi,
I'm using Oracle 5.0 and lately I've been getting ORA-06508 error messages. Its a client server application and I'm using Pro-C for my Comms. I tried to debug it and i found out th...
Hello,
Could someone could help me to find a best solution in such situation?
I am not satisfied with form's working while deleting record...
One way is to create a push_button and to w...
i want to change the default size of the database parameter like db_buffer_cache and shared_pool_size ,library_chace,hit_ratio to values that increase system performance by decreasing query re...
I have a larg text file which contains data as follows
First three lines are headings like ( a sample)
Ename Phone salary officephone
id_no fac ntnno grade
a...
Hi,
I need to create LOV from a multi line text item dynamicaly?
Is it possible?
Thanks.
I have a webserver running IIS inside a firewall. I have a db server running Oracle 9.2 inside the same firewalled network. IIS is set to windows authentication mode to secure it. I have a hol...
OK, I've been tasked with updating / repairing a companies web site. The site runs Cold Fusion and Oracle and all data is stored in Oracle.
NO ONE can tell me zippy about the Oracle data.
I ...
Hey experts!
I have a general question - IF your Oracle (9.2 or 10g) database has say, a terabyte of data in a single table, and you say select * from that table; TOAD somehow manages to r...
Hi experts,
I have been trying to select data from oracle(toad) to fill my datagrid, but it gives this error=
ORA-00904: invalid column name
but i have checked the column names in toad,...
hi guys
i am implementing a trigger which on execution should put the cursor or focus on a particular text item
i am using Go_Item(:block.item_name) but i am not able to get the focus t...
