Search results for query: *

I declared a dblink from server1 to server2, but i do not know how to use inside Oracle Forms 4.5. I know that using PL/SQL the sentence working as follow: select * from table_name@dblink_name but I tried to do this in forms and did not work. Anybody knows the rigth way to do this? thanks...

I am using Oracle Application Server 4.0 in a Unix server (server2). The DB is installed in (server1), I configured OAS in server2 to connecting to server1, I had been monitored the sessions that is created when a connection is making from server2, but do not match with the numbers of PC that...

I want to show only the last record in a ordered group and summarized. Is that possible? How could I do? Thank in advance

Hi How could I made a receipt in PO using interfaces? I want to receive a txt file with all information needed to make a receipt in Purchase Module. I am using Oracle Application 10.7.0 and RDMS 8.1.7.4.0 Thanks in advance.

I want to know how could I populate po_requisitions_interface_all to create manually PO´s? I have a 3rd party Software that we are using to calculate mim-max planning, and after this calculate I want to load the PO into Oracle DB. We have Oracle Apps 10.7.3 and Oracle DB 8i. thanks in advance...

How could I do math operations with datatime type variables? I want to do the next: date format MM/DD/YY HH24:MI date1 = '07/01/04 03:03' date2 = '07/01/04 16:30' I just want to query rows where date1 > date2 Any advice? thanks in advance

Why if I call this pl/sql req_id = 0? declare req_id number; begin req_id := fnd_request.submit_request('PER','BTOTMEMP', null,to_char(sysdate, 'DD-MON-YYYY'), TRUE,'CIA=1', 'YEAR=2004','MONTH=10',chr(0),null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null...

How could I use horizontal scroll bar in Oracle Forms 4.5? I need to scroll a block inside on a canvas. I will appreciate any help. Thanks in advance

I am working with Oracle Forms Developer, I programing a trigge, and it was working properly, but suddendly, this trigger become to fail, an I do not know why. I review every senences of the trigger and it is OK, but the trigger does not work properly, When I run the trigger my developer get...

I receive this error message: The following error has occurred: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.UTL_FILE", line 98 ORA-06512: at "SYS.UTL_FILE", line 157 ORA-06512: at "ES344.AR_AREXDESA", line 146 ORA-06512: at line 9 and this is the lines where I am...

When run this query select devcbs.p_ini(bell.cia, trunc(bell.INIT_DATE)) prueba from es344.b_empl_line_log bell CREATE OR REPLACE function p_ini ( ncia number, init date ) return number is per number; begin select bp.period into per from devcbs.b_periods bp where bp.cia = ncia...

Someone knows why Oracle 7.3.4 show me this error: The following error has occurred: ORA-06550: line 5, column 19: PLS-00905: object ES344.P_INI is invalid ORA-06550: line 5, column 3: PL/SQL: Statement ignored When I execute the next function: create or replace function es344.p_ini ( ncia...

What is wrong with this sentence? The following error has occurred: ORA-06550: line 5, column 20: PLS-00905: object DEVCBS.RCURSOR2 is invalid ORA-06550: line 5, column 3: PL/SQL: Statement ignored This is the sentence that I am running. in PL-SQL CREATE OR REPLACE FUNCTION rcursor2 (p_cia...

Hi I need help with an issue that I have. How could I make a mark with a specific colour in a block if I had a specifi value in my table. I am showing the information from a table into a block with 12 records displayed property and I want to show with a colour a specific record inside the...

I need help with a query thet I need to make a report. I have this info. Table Name 'header' Fields Id, PartNumber, CodeNumber, Quantity Info 1, 12345, C12345, 10 2, 67890, C67890, 25 3, C12345, , 23 4, C67890, , 15 5, 54321, C12345, 5 I want to show in a single query row...

I need an Urgent Help. I will appreciate your feedback. When I run this report, the application show me the follow error: +---------------------------------------------------------------------------+ Oracle Receivables: Version : 7.0.152 - Development Copyright (c) Oracle Corporation 1979...

Hi I want to use sql loader inside Oracle Forms 4.5, How could I do this? I just want to made a when-button-pressed trigger and load any info from excel to oracle. It would be wonderful if someone give me a code clue for Oracle Forms 4.5. Thanks in advance.

I need help to solve thie question. How could I export data from Excel to Oracle using PL/SQL? I really appreciate any help. Thanks in advance. K'zaz

Hi, I want to put over my command button a descriptive icon, but I can not. What is te steps to do this? I am using Oracle Forms 4.5. Thanks in advance.

How could I call an Oracle reports made in Reports 2.5 from Oracle forms 4.5? I just want to press a button, and when it is pressed send the parameters and display the report. thanks in advance for help. JCasas