How to develop a executable for develper 6i
How to develop a executable for Oracle Forms 6i & Report 6i
How to develop a executable for Oracle Forms 6i & Report 6i
5 pts.
ORA-01031 Insufficient privileges
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages
Delphi application freezing on search
We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.
We have a deplhi application running. Sometimes (NOT all the time) when the user selects a search criteria and enters the search field, the application freezes after displaying the results in the grid. The grid that displays the search result is of type TAdvStringGrid. Backend is Oracle.
View .pdf file from Oracle Forms 10g
Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...
Using Oracle Forms 10g version 9.0.4.0.19 that runs on a Sun Solaris box version 9. The application is web-based, and would like to add new functionality to an existing form. The user has the ability to upload .pdf files to the database from their local/network drive and download the .pdf files...
Calculate time difference with Oracle 9i
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i...
1)i wanna calculate difference between current time and time which is stored in table. how will i calculate the difference between 2 time?? 2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i...
Call parameter from Oracle Reports 10g web.show_doc
the code DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:\testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; is running well. But now i want the report's parameter form to be displayed....
the code DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:\testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; is running well. But now i want the report's parameter form to be displayed....
How can we pass Oracle username/password programmically?
i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.
i want to add record in one table but by using 2 different usernames. for example, i want to save products information by using username: POS, but i want to use username: Stark to add new department in department table.
How can we call different canvases within one window?
i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.
i want to design a form with three canvases. but problem is occur that other two canvases are not shown at run time. i want to create a push button and when i press it then 2nd canvas must be open.
How user parameters are created in Oracle Reports 10g
how user select the parameter from the parameter list and how it is created
how user select the parameter from the parameter list and how it is created
Can I run Seconds on an Alert in Oracle Forms 6i
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
View Answer
| Apr 22 2009 5:53 AM GMT
Time On Alerts in Oracle Forms 6i, Oracle Forms 6i, Oracle development
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
View Answer
| Apr 22 2009 5:53 AM GMTTime On Alerts in Oracle Forms 6i, Oracle Forms 6i, Oracle development
Dear Carlos De Leon... Kindly help me out
Hi.... Dear Carlos De Leon You have told that i have to do that by saving the value of the parameter in the database and use it later when i need that.... Can you please help me out how can i do that.... we will have to pas as much parameters as the number of colums in the report.. caN you [leas...
Hi.... Dear Carlos De Leon You have told that i have to do that by saving the value of the parameter in the database and use it later when i need that.... Can you please help me out how can i do that.... we will have to pas as much parameters as the number of colums in the report.. caN you [leas...
A program is trying to automatically send email on your behalf (Outlook via Oracle Developer 6i)
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want to show...
whenever i am trying to send mail via outlook from oracle developer forms 6i it asked for a confirmation from user. ie:--- a program is trying to automatically send email on your behalf do you want to allow this? if this is unexpected it may be virus and you should choose no I dont want to show...
Oracle SQL question
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't...
I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't...
How to create procedure in Oracle
I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID ...
Answer Question
| Apr 11 2009 12:28 AM GMT
Oracle development, Oracle import/export, Microsoft Excel import/export
I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID ...
Answer Question
| Apr 11 2009 12:28 AM GMTOracle development, Oracle import/export, Microsoft Excel import/export
Using INSTEAD OF Views in Oracle Forms 6i
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...
I have a block in my forms which is based on a view. I have created an instead of trigger on this view tu update certain fields. I would like to update this view through a Forms. I have made the block and the field updatable, but it gives me the following message when I try to write something on...
DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...
Please help . What I am doing wrong
Dim cmd As OracleCommand Dim ds As DataSet Dim dv As DataView Dim da As OracleDataAdapter = New OracleDataAdapter ' This does not work.. which is what I need, Country and State are entered by the user - cmd = New OracleCommand("Select...
Dim cmd As OracleCommand Dim ds As DataSet Dim dv As DataView Dim da As OracleDataAdapter = New OracleDataAdapter ' This does not work.. which is what I need, Country and State are entered by the user - cmd = New OracleCommand("Select...
Appeon with Oracle
How to Configure Oracle Data Base with Appeon.
Answer Question
| Mar 31 2009 7:24 AM GMT
Appeon with Oracle, Appeon for PowerBuilder, Oracle interoperability
How to Configure Oracle Data Base with Appeon.
Answer Question
| Mar 31 2009 7:24 AM GMTAppeon with Oracle, Appeon for PowerBuilder, Oracle interoperability
iSQLPlus creating packages with multiple procedures in it
Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...
Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...
Oracle Forms 6i Database Objects
I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you
I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you
