Search results for query: *

Hi all, Am new in application server. I did an upgrade from version 6i to application server 9i. I managed to run the forms successfully but I have this problem of running the reports from the form. When I try, am getting the message "Enter your Single sign-on username and password". How do I...

Hi all, I have this problem with developer 10g. When I try to run a report, in paper layout it works well but when I try to run the same report in web layout, am getting a blank page. Any one with a solution or similar problem? Any assistance will be appreciated.

Hi all, I have this problem with developer 10g. When I try to run a report, in paper layout it works well but when I try to run the same report in web layout, am getting a blank page. Any one with a solution or similar problem? Any assistance will be appreciated.

Am trying to work on the application server but when I refresh, am getting an error; Failed to connect to the server:/forms90/I90servlet:-1 What could be the problem?

Hi all, I want to do a select statement and the scenario is as follows; Table T has columns C1, C2, C3 and C4 with the following data: C1 C2 C3 C4 A 10 23 T B 25 25 T C 11 04 T B 06 25 T C 13 24 X A 24 35 T A 07 25 X C 10 45 T I want to do a sum of C2 & C3 for items A, B & C, i.e to do a...

That could work but its not accurate as it is assuming 31 days in a month.

If I want to get the number of days between two dates say 01/01/1995 and 26/12/2000, it is simply (26/12/2000)- (01/01/1995). Now the problem is converting the days into years. Any idea?

I have this problem of being unable to save records to the database using an application which initially used to work well. In the save button, I have a function when I try debugging, it keeps on repeating itself hence the system hanging. What could be the problem and a solution to this? Any...

My problem is that I have created some buttons property iconic and given the icon name. At the layout editor the icon picture appears well but during runtime it disappears. What could be the problem??

This is what I have for a when_button_pressed trigeer: (In developer 9i) declare repid report_object; v_rep varchar2(200); rep_status varchar2(20); begin repid := find_report_object('report_name'); v_rep := run_report_object(repid); end; When I press on the button, I get the message...

When I run a form am getting the error subordinate mirror item DB_REPORTS_VIEW_1.DISP_REP_TITLE. FRM-30457: Warning: Maximum Length ignored for character-datatype subordinate mirror item DB_REPORTS_VIEW_1.DISP_REP_SUBTITLE. What could be the cause?

The solution is simply getting the application property for the user!!! <Variable>:= Get_Application_Property(USERNAME);

Sorry I meant Oracle developer 6i and am trying to get the application user as in the user who is currently logged on to the application

In 6i, am able to select the global user as: select <field> into <variable> from <table> where <field>= upper(:global.sysuser); but when i try the same in 9i i get the message 'no data'. Anyone with a solution?

Hi I am trying to run a form but getting an error FRM-40513 - Oracle error. Unable to get date/time from database. I tried running the same form in a diffrent computer and it worked but when i installaed the application in another computer, it's when I got this error. Any one with a solution?

This is the script: SELECT "EMPLOYEES"."FIRST_NAME", "EMPLOYEES"."MIDDLE_NAME", "EMPLOYEES"."LAST_NAME", "EMPLOYEES"."JOB_CATEGORY", "EMPLOYEES"."AREA", "INVOICE_LINES"."STAFF_NUM", "INVOICE_LINES"."AMOUNT"...

I want to do a report which is from different tables and I want to use the group by function e.g select a.staff_num, sum(a.amount), b.first_name, b.last_name, c.staff_num where ........ group by a.staff_num; When I try to execute, I get an error message not a group by function. What could be...

Try this code: FUNCTION Ini_pass_decrypt RETURN varchar2 IS v_length number(20); v_check number(20) := 1; v_decrypt varchar2(1); v_asc_decrypt number(3); v_dbpwdencrypt varchar2(20); BEGIN v_length := NVL(length(:global.dbpwdencrypt),0); WHILE v_length + 1 >...

Perhaps if I can see the SQL statement you have and all the fields in your datawindow.

I have this problem of writing to a .prn file. The problem is that some records are duplicating themselves and others are not picked. Other records are picked well. I am not so good in PowerBuilder but I believe somebody out there has a solution. Please assist. Thanks