What way you use for this task.....??
have you create ODBC connection????
[UserName/Password]@ODBC:DataSourceName
hope it will solve yours problem
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Search found 132 matches
- Wed Jul 05, 2006 2:06 am
- Forum: Oracle Forms & Reports
- Topic: Form6i Connect To Sql SQLServer
- Replies: 1
- Views: 2069
- Wed Jul 05, 2006 2:03 am
- Forum: Oracle Forms & Reports
- Topic: how form opening time get data as per given date
- Replies: 1
- Views: 1283
Use this code for yours problem.. <b>declare vtypev varchar2(15); v_Where Varchar2(200); BEGIN vtypev :='BPV'; v_Where := 'vtype='||''''||vtypev||''' and entdate between ''01-Jul-05'' and ''30-Jun-06'''; set_block_property('voumaster', default_where, v_Where); go_block('voumaster'); execute_query; s...
- Mon Jul 03, 2006 6:54 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: HOW GET LANDSCAPE REPORT
- Replies: 2
- Views: 2678
- Mon Jun 26, 2006 6:18 am
- Forum: Oracle Forms & Reports
- Topic: Dynamic values report
- Replies: 2
- Views: 1694
I am unable to understand yours requiremnt or problem.... please me in brief, according to me there is no problem in yours requiremnt because you need to run report which based on 2 parameter which are based on each other.....??? takre care Best regards, R E H A N M I R Z A System Analyst / Senior O...
- Mon Jun 26, 2006 6:06 am
- Forum: Oracle Forms & Reports
- Topic: Oracle_ExcelSheet
- Replies: 1
- Views: 1357
Assalam-o-Alaikum Aijaz use TEXT_IO package for yours require task if any confusion please reply i will send you code base on emp table take care Allah Hafiz Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray Please remember me and my ...
- Fri Jun 23, 2006 6:36 am
- Forum: General / Others
- Topic: List of value should perform following
- Replies: 6
- Views: 3597
- Wed Jun 21, 2006 6:19 am
- Forum: Oracle Forms & Reports
- Topic: Problem with Sys_Context
- Replies: 0
- Views: 1103
Problem with Sys_Context
I am trying to get Os_User name with this Sql Statement, but it give me error i m user "<b>Oracle8i Enterprise Edition Release 8.1.5.0.0</b>" SQL> SELECT sys_context('USERENV', 'OS_USER') FROM dual; SELECT sys_context('USERENV', 'OS_USER') FROM dual * ERROR at line 1: ORA-02003: invalid US...
- Tue Jun 13, 2006 9:51 am
- Forum: Oracle Forms & Reports
- Topic: Multiple Instance of an Application.
- Replies: 25
- Views: 990769
- Tue Jun 13, 2006 9:45 am
- Forum: Oracle Forms & Reports
- Topic: Multiple Instance of an Application.
- Replies: 25
- Views: 990769
- Tue Jun 13, 2006 6:44 am
- Forum: Oracle Forms & Reports
- Topic: see my problem
- Replies: 4
- Views: 3885
- Tue Jun 13, 2006 6:17 am
- Forum: Oracle Forms & Reports
- Topic: Multiple Instance of an Application.
- Replies: 25
- Views: 990769
- Tue Jun 13, 2006 6:13 am
- Forum: Oracle Forms & Reports
- Topic: Multiple Instance of an Application.
- Replies: 25
- Views: 990769
Assalam-o-Alaikum Thanks alot for yours valueable reply.... please tell me about yours problem of Comm. OCX is it solved??? Once again thanks for yours cooperation. take care Allah Hafiz Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pr...
- Tue Jun 13, 2006 5:45 am
- Forum: Oracle Databases
- Topic: Make Condition in Decode Function (Tip)
- Replies: 2
- Views: 2147
Make Condition in Decode Function (Tip)
Senerio: Table name GLTbl have 2 Column AmtDr and AmtCr If Sum(AmtDr) > Sum(AmtCr) then Sum(AmtDr) - Sum(AmtCr); ElsIf Sum(AmtDr) < Sum(AmtCr) Sum(AmtCr) - Sum(AmtDr); Else 0; End If; Select Decode( Sign(Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0)), 1, Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0),-1, Nvl(Sum(Amt...
- Tue Jun 13, 2006 5:03 am
- Forum: Oracle Forms & Reports
- Topic: FRm-40509 oracle error : unable to update record
- Replies: 3
- Views: 4491
If you attached default menu, In form runtime go Help then show error. It will database error message and also error statement. Post that error message here so we will help you more easily. take care Allah Hafiz Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304...
- Tue Jun 13, 2006 4:53 am
- Forum: Oracle Forms & Reports
- Topic: FRm-40509 oracle error : unable to update record
- Replies: 3
- Views: 4491
Assalam-o-Alaikum I think you have not athority for update record on specified table....... Please tell when you insent record form that from is it succeed or not??? the problem exist only with update??? take care Allah Hafiz Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer...