How to develop a executable for Oracle Forms 6i & Report 6i
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
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.
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...
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...
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....
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 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 select the parameter from the parameter list and how it is created
I want to run time on an alert showing even the seconds (changing values). Have someone done this? Please help me out.
Time On Alerts in Oracle Forms 6i, Oracle Forms 6i, Oracle development
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...
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...
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 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 ...
Oracle development, Oracle import/export, Microsoft Excel import/export
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...
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...
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...
How to Configure Oracle Data Base with Appeon.
Appeon with Oracle, Appeon for PowerBuilder, Oracle interoperability
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...
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


