Search results for query: *

Yes, I can access using TOAD or sql*plus but I cannot uing forms. Is anything missing? regards

Forms 4.5 shows me this error Error 356 table_name@dblink_name must name a table to which the user has access. Regards

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.

Santa Mufasa Your script was perfect, that's the information that I was looking for. thanks

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...

thanks very useful, and if I want to know the minutes between 2 times. date1 = '07/01/04 03:03' date2 = '07/01/04 16:30' result = date1 - date2 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...

The function is working now, thank you for your help. I really appreciate your help. Do you know any training to use PL-SQL, Oracle Developer Forms and Reports? This is to learn some mor tips, because I was learning by myself, and it is a very hard way. thanks for the information.

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...

Mufasa, I did as you say, and after create the function, I recompile it with the sentence that you give me, and does not work, the function still show me the same error, and it still create with compilation errors. After I run Alter show me this: Warning: Function altered with compilation...

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...