I have the following:
----------------------------------------------------------------------------------
REM test.sql
CREATE FUNCTION get_desc (in_code STRING) RETURN STRING AS
des...
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...
Is there a way to generate oracle report in pdf format
Im using Access 2003 and I wanted to know if there is any way that I can create a view like in sql that will show a diagram of the tables and the keys. The will be of linked tables. Any 3rd ...
Actually i have read the one posted question here. however, i am using the port 1531 for better network with SDU and TDU sizes for newly created listener. i monitor the coming in public which ...
I have a small question on recursive sub programs in Oracle. I have a one procedure xx_FIRST with one parameter. In this procedure at circumstances I need to call the same procedure with diffe...
I have lately used net manage ($ORACLE_HOME/bin/netmgr) to
set the listener password to abcd.
Now if I try to stop the listener at the command prompt, this is what happens:
$cd $ORACLE_H...
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...
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...
Whenever a constraint is violated inserting records thru a Form developed with Forms 6i, DBMS_ERROR_CODE reports error 1403 (NO DATA FOUND) instead of ORA-00001.
If you go to Help --> Er...
Hi Experts,
I wrote this code in Developer 10g to call a report
in the trigger when-button-pressed
declare
rep_command varchar2(1000);
repid REPORT_OBJECT;
v_rep VARCHAR2(100);...
hi all,
I would like to request your help for solving a scenario i am having in oracle reports 6i.
i have a report having data spanned to multiple pages.
i have a new requirement. In...
I have a datablock in a Tabbed Form and this block has a database item called "status" which is a checkbox form that has a value of Y or N. My question is, when I query all the records, is it...
Hello, I am using Forms 6i.
What type of trigger and what syntax should I write if I need to automatically update foreign key field (loc_no for example) in the TEST table (for example) ...
Environment : Oracle Application 11i/Forms 6i sp5
I am now going to submit request/request set in form.
And I have some questions about it:
(1)Which package/library can I use to submit ...
I have created a report in Oracle report writer. I have also compiled this report to a .REP file. What do I need to do to make this report available for someone to run on the client side sim...
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...
Hi everyone, ive developed a fleet tracking software using VB6 and Oracle 9i. Ill give u a brief desc of how the software works. Each vehicle is fitted with a firm wear which gives its positio...
my database consists of different tables, i am trying to design a form as follow:
1. list item (this list item will be populated with player email addresses from player table)
player(p_i...
I'm sure this is very simple but I just cant find any docs on this: How do I insert a trademark (TM) to registered (R) symbol into an oracle 8i table? I'm extracting data from another source...
When using Oracle Forms6i Client/Server default menu or customized menu, the status message does not get refreshed when the end-user use the smart icons.
e.g.
(1) start the Form
(2) exec...
Does anyone know of/where I can find such a utility? I would need the documentation as well.
I'm running a master form and I query records. Then I click on a button which then passes the primary ID by calling a detailed form. If based on the primary ID (which is the foreign key to t...
I get a message that says "Export terminated unsucessfully".
This is in the log file:
Connected to: Personal Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Producti...
How could I generate XML file from oracle table?
