How to avoid Oracle Form to perform commit action ?
I have a question. The case is: After a user correct some data displayed in text items, he needs to click a button to update the record. However, the oracle form the commit the update action. I don’t want to allow Oracle Form to perform commit UNTIL the user closes the oracle form. Is it [...]

Answer Question   |  November 7, 2011  1:52 PM
Oracle Forms

pl/sql fixed file creation
I am new to the pl/sql world. I’m ok with writing out a comma delimited file but I can’t figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

Answer Question   |  October 28, 2011  12:48 PM
PL/SQL, SQL

FRM-40403 A CALLING FORM HAS UNAPPLIED CHANGES SAVE NOT ALLOWED
Dear Friends I have order data entry screen form when the order item is not yet defined then I am using this script for calling the item definition form DECLARE l_n_curr_rec NUMBER; BEGIN BEGIN :global.l_n_curr_rec2 := :COP_ORDER_DETAILS.LINE_NO; :GLOBAL.CLASS_CODE := :CLASS_CODE; :GLOBAL.LINE_NO := :LINE_NO; :GLOBAL.USER_ID := ’1′; END; :global.cop_order_code := :cop_order_details.cop_order_code; :global.ord_date := :cop_order_details.ord_date; :global.command_line := [...]

Answer Question   |  November 4, 2011  5:13 AM
Oracle 9i

Free IT Book: Demystifying the Virtual Desktop
Interested in desktop virtualization? This week’s free IT book is just what you need. Michael Fox’s Demystifying the Virtual Desktop Starting with Desktop Virtualization is a quick read that breaks down the business and technical complexities of virtual desktops. Simply answer one of five questions and post the link to your answer in the discussion [...]

Answer Question   |  May 4, 2012  2:23 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Problems calling report using WEB.SHOW_DOCUMENT
I am using Oracle Report and Forms 10G and trying to call a report from Forms using the following code: DECLARE rep_url VARCHAR2(2000); BEGIN rep_url:=’/reports/rwservlet?’ ||’&report=C:Oracle DbDEPARTMENT_EMPLOYEES.jsp’ ||’&desformat=htmlcss&destype=cache’ ||’&userid=name/password@orcl’ ||’&PARAFORM=yes’; WEB.SHOW_DOCUMENT (rep_url, ‘_blank’); END; When the button is click, it does not open a the report’s parameter form, but a blank report page. I’ve also [...]

Answer Question   |  October 14, 2011  2:02 AM
Oracle Application Server, Oracle developers, Oracle Forms, Oracle Forms 10g, Oracle Reports

Verify if a Patch is installed for Solaris 10
I need to check if 2 patches (120753-05 & 120048-03) have been installed for Solaris 10. How do I check that they have been installed.

Answer Question   |  October 15, 2011  3:30 PM
Installing/upgrading operating systems, Oracle patches, Solaris10, SPARC

Open IT Forum: What tech CEO would you vote for?
Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!

Answer Question   |  March 9, 2012  7:46 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

oracle forms 11g – Calling .DLL files from forms
What is the best way to call a PRO C .dll file from forms 11g. (Would rather not have the files reside on the client)

Answer Question   |  October 12, 2011  2:10 PM
Oracle 11g, Oracle Forms, Oracle Forms 11g

conversion of oracle trigger to MS SQL
how can i convert an oracle trigger into MS-SQL?

Answer Question   |  October 12, 2011  1:49 PM
MSSQL, Oracle triggers, SQL connectivity, SQL Server

Image in Oracle 8i
i have connect vb and oracle. i want to store a image in oracle 8i throw vb? plz help me

Answer Question   |  October 11, 2011  12:29 PM
Oracle 8i, Oracle Query, Visual Basic

problem about using Oracle Form 6i to connect Oracle Database 10g express.
Sorry to interrupt all of you. I have encountered a problem about using Oracle Form 6i to connect Oracle Database 10g express. As I would like to I use Oracle Net8 Easy Config to create a connection. According to “tnsnames.ora”, the paramater of connection is as follows; XE =   (DESCRIPTION =     (ADDRESS = [...]

Answer Question   |  October 11, 2011  4:20 PM
Oracle 10g, Oracle 10g administration, Oracle Database, Oracle Forms 6i

lora-01017:invalid username/password
hi finally i installed oracle application server (client) successfully and i connected the oracle database 10g (server) with the (oas) and they work fine i finished the configuration for net config assistant and all user in oas and database are connected the problem is when i want to run my forms in the oas i [...]

Answer Question   |  March 31, 2012  5:41 PM
Oracle 10g, Oracle Application Server, Oracle applications, Windows Server 2003

Oracle Forms Builder 6i – Run Debug
I just installed forms builder 6i not too long ago. I am able to do everything but run the debug. Everytime I try the run/debug, it looks like it is running but it is creating a file icon on my machine. When I open up this file, I am getting a fatal error. The error [...]

Answer Question   |  March 31, 2012  5:24 PM
Oracle Forms, Oracle Forms 6i, Windows XP Professional

EXTENDED: IT Scripts Contest now ends October 17
It’s not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don’t have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries [...]

Answer Question   |  March 31, 2012  3:30 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Scripts, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Return only one word– SQL
Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. [...]

Answer Question   |  March 31, 2012  7:12 PM
Oracle, Oracle SQL, SQL, SQL Server

What is the next step after installing oracle application server?
hi , first i installed (oracle database 10g) then i installed (oracle application server 10g)  in my computer (windows server 2003) and i want to run the form’s , note that  theese form’s i desgned it in other computer i need to know what is the steps to configure and run the form’s without installing [...]

Answer Question   |  March 31, 2012  4:38 PM
Oracle, Oracle 10g, Oracle Application Server, Oracle Database, Oracle Database 10g

How can do iSQl*Plus login for DBA
I want to create iSQL*Plus login for DBA. How can i do this ?

Answer Question   |  March 31, 2012  4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server

Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?
We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there’s a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don’t [...]

Answer Question   |  April 28, 2012  4:44 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Free IT Book: IP Networking
We’re giving away a detailed and practical overview of TCP/IP networking in IP Networking. From the publishers: “IP Networking takes you from a broad and basic knowledge of IP addressing and routing to a solid skill level with how hosts, switches, and routers collectively deliver IP packets in modern corporate networks, helping prepare you for [...]

Answer Question   |  March 31, 2012  4:00 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Oracle report 6i, report has 2 parameters and runs fine independently but i run this report from a form with parameters; reports ignore the parametrs
Report runs fine separately but when i call from a form and pass on required paramets, it does not show anything;

Answer Question   |  March 31, 2012  4:26 AM
Oracle 9i, Oracle 9i export parameters, Oracle default parameters