Hello Oracle Masters,
I'm currently using oracle forms developer vers 6i. Creating my own menu - 'MENU1' - I try to navigate thru the forms using 'NEW_FORM('formname.fmx');
question/pro...
Hi,
I have procedure which need to compare the varchar2 field. I tried different way but I am not able to put single quote during variable comparison. if I hardcode single quote with valu...
Hi,
I am calling an Oracle stored procedure from an ASP.Net application.
The Oracle Stored Procedure is:
----------------------------------------------------------------------
CREATE...
i am using toad to develop pl/sql
there is a way to check values in ys_refcursor during debug??
I have a button on my first window and in the WHEN-BUTTON-PRESSED of this I have this code:
HIDE_WINDOW('win1');
SHOW_WINDOW('win2');
Although the second window opens its hidden behind th...
In my form, I have a data block which has a "where" clause that fetches multiple records, i.e. maximum 10 to a block and displays them. If I execute the command "Create Record" followed by "...
Hi*!
I hav OCI application. In I am trying to get the table name present in the DB.
Here is my code
bool bRet = false;
OCIStmt* InsertStmt;
sword empno;
OCIDefi...
I have 3 different ref cursors which stores data for 3 different years. The ref cursors have 4 columns of
Dept,Manager,Emp Name ,Salary(of each year).
I need to form a 2 dimensional array...
Hi,
I'm hoping someone can help. I have a VARCHAR2 field from which I need to extract a specific peice of the string. The problem is that this is not always in the same place in the string,...
Hi,
I am trying to execute the following query
select * from wsh.wsh_locations
I am getting the following error in toad
OCI-22303: type "MDSYS
I tried executing the same quer...
I am trying to terminate a client connection based on idle time.
I have tried to use FORMS60_TIMEOUT and heartBeat as described on metalink (ID 109471.1) and in this site with the title "We...
How do you perform Oracle transaction counting?
Hi I having trouble trying to wrap a function I have created. I get the following error when I wrap the function on the dos prompt:
$ wrap iname=decrypt_string.sql oname=decrypt_string_wrap...
In order to validate a record, I need to compare it to other records in the same block. At the simplest level, I need to prevent a Unique violation. I've put code in the ON-ERROR trigger to ...
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 ...
Hi there,
I'm running a vb application which connect to Oracle via ODBC.
I get this error message when it running my SQL statement, which is only a select statement... [Oracle][ODBC]Invali...
Hello experts,
I can't find the STNDRD20.OLB and CALENDAR.PLL any where !!
I tried the other names,extentions and different pathes but it's not there
please can anybody send it to my ema...
I need to customize a form because my client doesn't want to see the Oracle corporative logo in the top of the screen (right side), they want to see there their own logo. Is there a way to mod...
HI GUYS,
I HAVE A DATABLOCK WHICH IS SET TO DISPLAY 20 RECORDS.. tHIS DATBLOCK CONTAINS 8 ITEMS. I HAVE SET THE DENY UPDATE PROPERTY ON 7 OF THESE ITEMS WHICH CANNOT BE CHANGED AND LEFT T...
I need some advice from experienced Oracle users - what is generally the quicker way to load data into database - loader with direct path or using insert and database link (remote server)?
I am facing some problems while establishing the ConnectionString for my Personal Oracle 8.1.7 edition.
When I want to start SQL*Plus, with out giving any Connectionstring (just user name a...
Hi,
Is it possible to change the message : "REP-0771: After parameter form trigger failed"
to personalized message in oracle reports.?
Thanks for answers
I am developing a student enrolment system. There is a master table for basic info. The table name is STUDENT. Then I have a table SDETAIL(subject,timing,credits, ... etc) for each individual ...
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) ...
Does anyone know what the SQL code would be in TOAD to do an Inner Join on an Oracle database?
